Click here to Skip to main content
15,925,369 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Visual Studio 2008 Beta 2 Pin
Sherin Iranimose8-Aug-07 23:58
Sherin Iranimose8-Aug-07 23:58 
QuestionFocus on desired button..? Pin
fmlove8-Aug-07 22:14
fmlove8-Aug-07 22:14 
AnswerRe: Focus on desired button..? Pin
N a v a n e e t h8-Aug-07 22:49
N a v a n e e t h8-Aug-07 22:49 
Questionasp.net and vista home basic Pin
S A R I T H8-Aug-07 22:13
S A R I T H8-Aug-07 22:13 
Questionconvert HTML content of .aspx page to PDF file Pin
Imran Khan Pathan8-Aug-07 21:57
Imran Khan Pathan8-Aug-07 21:57 
AnswerRe: convert HTML content of .aspx page to PDF file Pin
N a v a n e e t h8-Aug-07 22:50
N a v a n e e t h8-Aug-07 22:50 
GeneralRe: convert HTML content of .aspx page to PDF file Pin
Imran Khan Pathan8-Aug-07 23:17
Imran Khan Pathan8-Aug-07 23:17 
QuestionError:Value cannot be null. Parameter name: dataSet.., Pin
Member 38798818-Aug-07 21:53
Member 38798818-Aug-07 21:53 
Hi plz see the following code:
I am getting error as "Value cannot be null. Parameter name: dataSet" at the place i have mentioned with bold letters...,

For Each Maingrd As DataGridItem In dgrdmain.Items
Dim chk As CheckBox = CType(Maingrd.FindControl("chk"), CheckBox)

If chk.Checked = True Then 'checked true
Dim eid As Integer = Maingrd.Cells(1).Text
Dim sdloan As Double
Dim sdinstall As Integer
If Val(Maingrd.Cells(29).Text) <> 0 Then
mySqlDataAdapter = New SqlDataAdapter("Select top 1 * from tblsalarydetails where empid='" & _
eid & "' and (datepart(yyyy,edate) < '" & Val(ddlYears.SelectedItem.Value) & "' or (datepart(yyyy,edate) = '" & _
Val(ddlYears.SelectedItem.Value) & "' and datepart(mm,edate) <= '" & Val(ddlMonth.SelectedItem.Value) & "')) order by edate desc", sqlconn)
mySqlDataAdapter.Fill(myDataSet, "tblSalaryDetails")
If (myDataSet.Tables("tblSalaryDetails").Rows.Count) > 0 Then

If TypeOf (myDataSet.Tables(0).Rows(0)(27)) Is DBNull Then
sdloan = 0
Else
sdloan = Val(myDataSet.Tables(0).Rows(0)(27))
sdloan = sdloan + Val(Maingrd.Cells(29).Text)
End If

If TypeOf (myDataSet.Tables(0).Rows(0)(30)) Is DBNull Then
sdinstall = 0
Else
sdinstall = Val(myDataSet.Tables(0).Rows(0)(30))
sdinstall = sdinstall + 1
End If
End If

sqlCmd = New SqlCommand("update tblsalarydetails set loan='" & sdloan & "',Installment='" & _
sdinstall & "' from (Select top 1 * from tblsalarydetails where empid='" & _
eid & "' and (datepart(yyyy,edate) < '" & Val(ddlYears.SelectedItem.Value) & "' or (datepart(yyyy,edate) = '" & _
Val(ddlYears.SelectedItem.Value) & "' and datepart(mm,edate) <= '" & _
Val(ddlMonth.SelectedItem.Value) & "')) order by edate desc) as th where dbo." & _
"tblsalarydetails.edate = th.edate and dbo.tblsalarydetails.empid=th.empid", sqlconn)
sqlCmd.Connection.Open()
sqlCmd.ExecuteNonQuery()
sqlCmd.Connection.Close()
sqlCmd.Dispose()

sqlCmd = New SqlCommand("delete tblmonthsalary where projectid='" & _
Val(ddproject.SelectedItem.Value) & "' and eid='" & eid & "' and Smonth = '" & _
Val(ddlMonth.SelectedItem.Value) & "' and syear='" & Val(ddlYears.SelectedItem.Value) & "'", sqlconn)
sqlCmd.Connection.Open()
sqlCmd.ExecuteNonQuery()
sqlCmd.Connection.Close()
sqlCmd.Dispose()
mySqlDataAdapter.Dispose()
Else
exit sub
End If
End If 'Checked end
Next

Regards,
Magi

AnswerRe: Error:Value cannot be null. Parameter name: dataSet.., Pin
S A R I T H8-Aug-07 22:29
S A R I T H8-Aug-07 22:29 
GeneralRe: Error:Value cannot be null. Parameter name: dataSet.., Pin
Member 38798818-Aug-07 22:33
Member 38798818-Aug-07 22:33 
Questionhow t ochange the postions of sever controls . Pin
santoshkumarB8-Aug-07 21:41
santoshkumarB8-Aug-07 21:41 
AnswerRe: how t ochange the postions of sever controls . Pin
Sandeep Akhare8-Aug-07 22:29
Sandeep Akhare8-Aug-07 22:29 
QuestionProblem in Including Files Pin
cometburn0078-Aug-07 21:41
cometburn0078-Aug-07 21:41 
AnswerRe: Problem in Including Files Pin
Sandeep Akhare8-Aug-07 22:26
Sandeep Akhare8-Aug-07 22:26 
Questionevent validation error after creating datagrid bound columns programmatically Pin
Anees Mitha8-Aug-07 21:29
Anees Mitha8-Aug-07 21:29 
QuestionProblem with datagrid link Pin
S A R I T H8-Aug-07 21:19
S A R I T H8-Aug-07 21:19 
AnswerRe: Problem with datagrid link Pin
cometburn0078-Aug-07 21:29
cometburn0078-Aug-07 21:29 
AnswerRe: Problem with datagrid link Pin
N a v a n e e t h8-Aug-07 21:29
N a v a n e e t h8-Aug-07 21:29 
GeneralRe: Problem with datagrid link Pin
S A R I T H8-Aug-07 22:11
S A R I T H8-Aug-07 22:11 
GeneralRe: Problem with datagrid link Pin
N a v a n e e t h8-Aug-07 22:44
N a v a n e e t h8-Aug-07 22:44 
GeneralRe: Problem with datagrid link Pin
S A R I T H9-Aug-07 0:19
S A R I T H9-Aug-07 0:19 
QuestionHow to upload local text file to remote server.. using ftp Pin
dhulipudi8-Aug-07 21:12
dhulipudi8-Aug-07 21:12 
AnswerRe: How to upload local text file to remote server.. using ftp [modified] Pin
KernowMan8-Aug-07 22:31
KernowMan8-Aug-07 22:31 
AnswerRe: How to upload local text file to remote server.. using ftp Pin
shweta@syscom8-Aug-07 22:51
shweta@syscom8-Aug-07 22:51 
GeneralRe: How to upload local text file to remote server.. using ftp Pin
dhulipudi9-Aug-07 0:23
dhulipudi9-Aug-07 0:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.