|
|
Please help me this is my error
Object reference not set to an instance of an object(pointing this statement) Obj.addNewProject(txtProjectName.Text, txtProjectAbb.Text, txtClientSite.Text, cmbProjectManager.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, ListBoxProjectMember.SelectedItem.Text, txtProDuration.Text, txtCompletionDate.Text, txtProjectDuration.Text, txtProDescription.Text)
*************
This is my Code for Button Save
************
Protected Sub ButtonSave1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ButtonSave1.Click
Dim Obj As Businesslayer.TimeSheet = New Businesslayer.TimeSheet
Obj.addNewProject(txtProjectName.Text, txtProjectAbb.Text, txtClientSite.Text, cmbProjectManager.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, ListBoxProjectMember.SelectedItem.Text, txtProDuration.Text, txtCompletionDate.Text, txtProjectDuration.Text, txtProDescription.Text)
End Sub
**********
This is a class were I declared my variables
**********
Public Sub addNewProject(ByVal Project_Name As String, ByVal Project_Abb As String, ByVal Client_Name As String, ByVal Project_Manager As String, ByVal Project_Member As String, ByVal Project_Members As String, ByVal Est_Completion_Date As Date, ByVal Est_Project_Duration As Date, ByVal Project_Duration As Integer, ByVal Project_Description As String)
Dim Sql As String
Dim obj As Datalayer.Database = New Datalayer.Database
Sql = "insert into ProjectAdministration (Project_Name,Project_Abbreviation,Client_Name,Project_Manager,Project_Member,Project_Members,Est_Completion_Date,Est_Project_Duration,Project_Description,Confirm_Password,Project_Duration)" & _
" Values('" & Project_Name & "','" & Project_Abb & "','" & Client_Name & "','" & Project_Manager & "','" & Project_Member & "','" & Project_Members & "','" & Est_Completion_Date & "','" & Est_Project_Duration & "', '" & Project_Duration & "','" & Project_Description & "')"
obj.Execute(Sql)
End Sub
**********
I really don't understand this error.Can you please help me with it,What might be the problem?
Thanking you in Advance
oga m
|
|
|
|
|
It is hard to say what the problem is, but I would suggest that you put a break point in the code. Then check the objects to figure out which object is still set to Nothing. Once you figure out which object is set to Nothing then you might have a better idea of what is going on. If for some reason the code is getting executed in the load event the text boxes would not exist yet. Anyway, just a thought, hope it helps.
Ben
|
|
|
|
|
Oga M wrote: Object reference not set to an instance of an object(pointing this statement) Obj.addNewProject(txtProjectName.Text, txtProjectAbb.Text, txtClientSite.Text, cmbProjectManager.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, ListBoxProjectMember.SelectedItem.Text, txtProDuration.Text, txtCompletionDate.Text, txtProjectDuration.Text, txtProDescription.Text)
Usually this error will come when you are trying to use an object that is not been initialized yet. Make sure all objects are initialized before you use them.
|
|
|
|
|
My codes is shown below. Hopefully it should create a dataset. But how do I create a dataset in code using these values. Something like
<br />
Dim NewDataSet AS Dataset MadData.Cusomer_Lookup(Parameters here)
?
Public Class MadData<br />
'get application settings<br />
<br />
<br />
<br />
<br />
Public connectionString As String = ConfigurationManager.ConnectionStrings("MADConnectionString").ConnectionString<br />
<br />
Public Function Customer_Lookup(ByVal CustomerType As Integer, ByVal CustomerForename As String, ByVal CustomerSurname As String, ByVal LimitedTradingName As String, ByVal NonTradingName As String, ByVal AddressMobile As String, ByVal Records As Integer, ByVal Query As String) As DataSet<br />
<br />
'get the entity name to use for the DataSet table<br />
Dim dbConnection As New SqlConnection(connectionString)<br />
Dim dbDataSet As New DataSet<br />
<br />
Try<br />
'Create Command object for sp<br />
Dim dbCommand As SqlCommand = New SqlCommand("Customer_Lookup", dbConnection)<br />
dbCommand.CommandType = CommandType.StoredProcedure<br />
<br />
'input parameter variables - CustomerType<br />
Dim dbParameter As SqlParameter = dbCommand.Parameters.Add("@CustomerType", SqlDbType.Int)<br />
dbParameter.Direction = ParameterDirection.Input<br />
dbParameter.Value = CustomerType<br />
<br />
'input parameter variables - CustomerForename<br />
Dim dbParameter1 As SqlParameter = dbCommand.Parameters.Add("@CustomerForename", SqlDbType.VarChar)<br />
dbParameter1.Direction = ParameterDirection.Input<br />
dbParameter1.Value = CustomerForename<br />
<br />
'input parameter variables - CustomerSurname<br />
Dim dbParameter2 As SqlParameter = dbCommand.Parameters.Add("@CustomerSurname", SqlDbType.VarChar)<br />
dbParameter2.Direction = ParameterDirection.Input<br />
dbParameter2.Value = CustomerSurname<br />
<br />
'input parameter variables - LimitedTradingName<br />
Dim dbParameter3 As SqlParameter = dbCommand.Parameters.Add("@LimitedTradingName", SqlDbType.VarChar)<br />
dbParameter3.Direction = ParameterDirection.Input<br />
dbParameter3.Value = LimitedTradingName<br />
<br />
'input parameter variables - NonTradingName<br />
Dim dbParameter4 As SqlParameter = dbCommand.Parameters.Add("@NonTradingName", SqlDbType.VarChar)<br />
dbParameter4.Direction = ParameterDirection.Input<br />
dbParameter4.Value = NonTradingName<br />
<br />
'input parameter variables - AddressMobile<br />
Dim dbParameter5 As SqlParameter = dbCommand.Parameters.Add("@AddressMobile", SqlDbType.VarChar)<br />
dbParameter5.Direction = ParameterDirection.Input<br />
dbParameter5.Value = AddressMobile<br />
<br />
'input parameter variables - Records<br />
Dim dbParameter6 As SqlParameter = dbCommand.Parameters.Add("@Records", SqlDbType.Int)<br />
dbParameter6.Direction = ParameterDirection.Input<br />
dbParameter6.Value = Records<br />
<br />
'input parameter variables - Query<br />
Dim dbParameter7 As SqlParameter = dbCommand.Parameters.Add("@Query", SqlDbType.VarChar)<br />
dbParameter7.Direction = ParameterDirection.Input<br />
dbParameter7.Value = Query & "%"<br />
<br />
'open the Connection; run the sp; transform to a DataSet<br />
Dim dbDataAdapter As SqlDataAdapter = New SqlDataAdapter(dbCommand)<br />
dbDataAdapter.Fill(dbDataSet)<br />
<br />
Catch ex As System.Exception<br />
<br />
Throw ex<br />
<br />
<br />
Finally<br />
'tidy up<br />
dbConnection.Close()<br />
dbConnection.Dispose()<br />
<br />
End Try<br />
<br />
Return dbDataSet<br />
<br />
End Function<br />
<br />
End Class
|
|
|
|
|
You're missing an equals sign, but yes.
|
|
|
|
|
|
|
hi vasudevan and thanx for your reply.
It's not what i've been searching for, but surely it puts me on he right direction. Anyway, i'm not an Ajax programer and examples like you gave me helps a lot to learn. And nice scripts too must say.
cheers!
"I hated myself... no, I hated my place in the world" - From Jerry Maguire
|
|
|
|
|
how many columns datagrid hav ??
|
|
|
|
|
The screen real estate, good user experience of the application and Memory alone would dictate this limit right?
|
|
|
|
|
Hi,
I'm wondering how to do this, I'm working on the on a datagrid and I'm using windows authentication. I managed to get username on to a login form, but I want it to be stored into the database.The code of web config looks like:
authentication mode="Windows"
identity impersonate="true"
And the Login page looks like on(Page_load):
Response.Write(Page.User.Identity.Name);
Thanks.
|
|
|
|
|
What exactly is ur problem??
If u want to get the windows login name then use:
HttpContext.Current.User.Identity.Name
or else tell us what is the exact problem.
All the Best...
|
|
|
|
|
Thanks,
I want is when any one uses the website the Windows Login name should appear in a particular datagrid column automatically.
Thanks.
|
|
|
|
|
Your problem is solved or not????
|
|
|
|
|
Not yet solved. When I try using: HttpContext.Current.User.Identity.Name; I get error: Only assignment, call, increment, decrement, and new object expressions can be used as a statement.
Thanks
|
|
|
|
|
varshavmane,
I think this will help anderstand my problem is there a way The windows login can be saved automatically into database whenever a user uses the website? since I'm working with datagrid.
Thanks
|
|
|
|
|
Hi
I am using the asp:hyperlinkField in asp.net For this I am writing the following code in .aspx page
<asp:hyperlinkfield navigateurl="~/KB/KB_Detail.aspx?id=<%#DataBinder.Eval(Container.DataItem, "PK_KnowledgeBaseID") %>" datatextfield="s_Title" headertext="Title">
But it is not working properly.Please tell me the problem
Regards
Karan
|
|
|
|
|
When you post code in a forum you need to check the box below that says Ignore HTML tags in this message (good for code snippets)
Otherwise the code gets removed and we won't see it.
Thanks,
Ben
|
|
|
|
|
How do you access a template field in the gridview and assign it to the string, especially in the rowcommand function
nzibi
|
|
|
|
|
wrote:
TemplateField contains ItemTemplate, which has id. You can find that control in code behind using FindControl method.
Here[ ^] is some code snippets for same.
Knock out 't' from can't,
You can if you think you can
|
|
|
|
|
Please help me.I have declared my variables
***************************
Public Sub addTimesheet(ByVal IdNumber As String, ByVal ProjectName As String, ByVal ProjectMember As String, ByVal ClientSite As String, ByVal ProjectManager As String, ByVal Occupation As String, ByVal WeekNumber As Integer, ByVal Day As String, ByVal Hour As Integer, ByVal Description As String)
Dim Sql As String
Dim obj As Datalayer.Database = New Datalayer.Database
Sql = "insert into TimeSheet (Id_Number,Project_Member,Project_Name,Project_Manager,Hour,Day,Description,Client_Site,Occupation,Week_Number)" & _
" Values('" & IdNumber & "','" & ProjectName & "','" & ProjectMember & "','" & ClientSite & "','" & ProjectManager & "','" & Occupation & "', '" & WeekNumber & "','" & Day & "','" & Hour & "','" & Description & "')"
obj.Execute(Sql)
'addTimesheet = obj.GetDataset(Sql)
'obj.Close()
'Exit Sub
*******************************
Gives me this error
Conversion failed when converting the varchar value 'Select Project Manager' to data type int.(Pointing this query statement) lngRecords = cmdQuery.ExecuteNonQuery()
End Sub
******************
In my AddEntryButton
Dim Obj As Businesslayer.TimeSheet = New Businesslayer.TimeSheet
Obj.addTimesheet(txtIDNo.Text, cmbProjectName.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, cmbClientSite.SelectedItem.Text, cmbProjectManager.SelectedItem.Text, cmbOccupation.SelectedItem.Text, txtWeekNo.Text, cmbDays.SelectedItem.Text, txtHours.Text, txtDescription.Text)
*******************
What might be the Problem(explain it to me please)
oga m
|
|
|
|
|
Check the datatype of the data what you are sending from front end to the database.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Your code will fail with this sort of error whenever your strings contain a single-quote (e.g. "Fred's Project"). Try searching for "SQL Injection" or look at Parametorized SQL[^].
Regards
Andy
|
|
|
|
|
i want to display date in a datagrid column. To fill that datagrid i am filling data to a dataset and i am assigning that data set to datagrid.what my problem is that i am not able to display only date in that column.the time also is displaying with date.if i want to display time only then date also is coming along with time.
please help me to solve this problem
saravanan
|
|
|
|
|