|
Protected Sub btStart_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btStart.Click
Session("NoOfRecords") = 0
Try
sqlConn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("Constr")
'sqlConn.Open()
With sqlComm
.Connection = sqlConn
.CommandText = "OLE_InsertExamDetails"
.CommandType = CommandType.StoredProcedure
.Parameters.Add("@RollNumber", SqlDbType.Char, 100).Value = Trim(txtrollnumber.Text)
.Parameters.Add("@ExamDate", SqlDbType.DateTime).Value = "02-02-2009"
.Parameters.Add("@SemesterName", SqlDbType.Char, 20).Value = "One"
.Parameters.Add("@Papertype", SqlDbType.Char, 20).Value = RadioButtonList1.SelectedItem.Text
End With
sqlDataAdap.SelectCommand = sqlComm
sqlConn.Open()
'sqlReader = sqlComm.ExecuteReader
'If sqlReader.Read Then
' While sqlReader.Read
' Response.Write("<br>")
' Response.Write(sqlReader(0))
' End While
'End If
sqlDataset = New DataSet
sqlDataAdap.Fill(sqlDataset)
Catch ex As Exception
lblmessage.text = "Error while inserting"
End Try
sqlConn.Close()
'MsgBox(dt1.Rows.Count)
MsgBox(sqlDataset.Tables.Count)
MsgBox(sqlDataset.Tables(0).Rows.Count)
' FillDataSet(sqlDataset)
'display()
End Sub
this click event shows one table and no of records in the table
but when i click on another command button on same aspx page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' MsgBox(dt1.TableName)
MsgBox(sqlDataset.Tables.Count)
MsgBox(sqlDataset.Tables(0).Rows.Count)
End Sub
this it returns 0 and error cannot find table 0
modified on Monday, June 8, 2009 6:58 AM
|
|
|
|
|
On the click of another command button, other dataset might be re-initialized.
Either you love IT or leave IT...
|
|
|
|
|
govindi unal wrote: hv a code in click event of a command button in which i am filling a dataset
the dataset shows tables and table rows
but when i click on another command button
same dataset returns zero table and zero rows
Please put your code over here.
|
|
|
|
|
Protected Sub btStart_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btStart.Click
Session("NoOfRecords") = 0
Try
sqlConn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("Constr")
'sqlConn.Open()
With sqlComm
.Connection = sqlConn
.CommandText = "OLE_InsertExamDetails"
.CommandType = CommandType.StoredProcedure
.Parameters.Add("@RollNumber", SqlDbType.Char, 100).Value = Trim(txtrollnumber.Text)
.Parameters.Add("@ExamDate", SqlDbType.DateTime).Value = "02-02-2009"
.Parameters.Add("@SemesterName", SqlDbType.Char, 20).Value = "One"
.Parameters.Add("@Papertype", SqlDbType.Char, 20).Value = RadioButtonList1.SelectedItem.Text
End With
sqlDataAdap.SelectCommand = sqlComm
sqlConn.Open()
'sqlReader = sqlComm.ExecuteReader
'If sqlReader.Read Then
' While sqlReader.Read
' Response.Write("<br>")
' Response.Write(sqlReader(0))
' End While
'End If
sqlDataset = New DataSet
sqlDataAdap.Fill(sqlDataset)
Catch ex As Exception
lblmessage.text = "Error while inserting"
End Try
sqlConn.Close()
'MsgBox(dt1.Rows.Count)
MsgBox(sqlDataset.Tables.Count)
MsgBox(sqlDataset.Tables(0).Rows.Count)
' FillDataSet(sqlDataset)
'display()
End Sub
this click event shows one table and no of records in the table
but when i click on another command button on same aspx page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' MsgBox(dt1.TableName)
MsgBox(sqlDataset.Tables.Count)
MsgBox(sqlDataset.Tables(0).Rows.Count)
End Sub
this it returns 0 and error cannot find table 0
|
|
|
|
|
Please post code with proper formatting.
|
|
|
|
|
Protected Sub btStart_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btStart.Click
Session("NoOfRecords") = 0
Try
sqlConn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("Constr")
With sqlComm
.Connection = sqlConn
.CommandText = "OLE_InsertExamDetails"
.CommandType = CommandType.StoredProcedure
.Parameters.Add("@RollNumber", SqlDbType.Char, 100).Value = Trim(txtrollnumber.Text)
.Parameters.Add("@ExamDate", SqlDbType.DateTime).Value = "02-02-2009"
.Parameters.Add("@SemesterName", SqlDbType.Char, 20).Value = "One"
.Parameters.Add("@Papertype", SqlDbType.Char, 20).Value = RadioButtonList1.SelectedItem.Text
End With
sqlDataAdap.SelectCommand = sqlComm
sqlConn.Open()
sqlDataset = New DataSet
sqlDataAdap.Fill(sqlDataset)
Catch ex As Exception
lblmessage.text ="Error in inserting"
End Try
sqlConn.Close()
MsgBox(sqlDataset.Tables.Count)
MsgBox(sqlDataset.Tables(0).Rows.Count)
End Sub
it displays number of tables and corresponding records
but when i click on another command button ]
for number of tables it displays 0
and for number of rows it generates error cannot find table 0
|
|
|
|
|
|
GridView1.Columns.RemoveAt(columnIndex);
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
souravghosh18 wrote: I want to delete a gridview column programatically
You can remove like this way.
GridView.Columns.RemoveAt(<index>);
But, you should search google once before asking questions .
|
|
|
|
|
Hi There,
I want to start installation when user click on Install Button.If anybody know please suggest me some linqs.
Thanks.
|
|
|
|
|
ais07 wrote: I want to start installation when user click on Install Button.
So you want to execute installation file in web Application or in Windows Application.
if you want to do it asp.net web application you can do it using Process Class. But "This will Execute File ONLY ON SERVER NOT IN THE CLIENT" .
So, before putting question like that you should clear about your requirements.
Thank you
|
|
|
|
|
hello all....
how i can load a div pop up to my site without click the link....
i want that, if main page will laod, the div pop up appear for 15 second....
and after 15 second that go to appear...
how i can do that... help plz...
|
|
|
|
|
Did you try with javascript?
|
|
|
|
|
function showPopup()
{
document.getElementById('popup').style.display='block'; // show the popup
var t=setTimeout("document.getElementById('popup').style.display='none';",15000); //set it to hide it 15 seconds later
}
<body onload="showPopup()">
<div style="position:absolute; width:100%; height:100%; left:0px; top:0px; display:none;" id="popup">
Buy my stuff you silly panda..blah blah
</div>
</body>
Im not by a pc( ) so i havent tested this, should work tho
|
|
|
|
|
I am using a Ajax Modal Popup control for displaying error messages. it is a simple panel with a lable and a button. I am setting the .Text option of the label = to the error message string version but when I show the popup the .Text of the label is not shown. The property is filed because I 've made a watch on it an it contains the error but it is not displayed. Can someone help please?
|
|
|
|
|
Are you using partial updates with AJAX? Just check whether the label control is inside the update panel and whether the trigger is set properly if update mode is set to conditional.
Either you love IT or leave IT...
|
|
|
|
|
the button which is calling the popup is insid the update panel while the popup is outside the update panel. May be this is the cause? How can I solve it?
|
|
|
|
|
Do you set the text property of the label control on the button click event?
Either you love IT or leave IT...
|
|
|
|
|
Yes. does that affect the update panel?
|
|
|
|
|
Please correct me if I got anything wrong.
You are doing two tasks on button submit. One is setting the text of the label control on server side. The second one is to show the modal popup on client side. If the second one is true, then you will never be able to set the text property of the label control because the server side code to set the text will never be executed.
If I got the right situation then I may suggest you to call the ModalPopup from code-behind so that you can also set the text of the label control in one go:
ModalPopupExtender1.Show();
Label1.Text = "Yeppi, blah, blah, blah";
But showing the modal popup on a server side event may not be a best case.
Check it and revert back to me in case of any confusion.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
I am currently doing like that but it is not working
|
|
|
|
|
Post the code.
Either you love IT or leave IT...
|
|
|
|
|
saanj, late to wish.. Congrats for Sharepoint Forum .
BTW: I think you have missed out Fossils name in your favorite music band list. Am i correct ?
|
|
|
|
|
Hey Abhijeet,
Congrats to you as well and thanks for your wish and support. Cactus is the band which I might have missed in my list but I am quite sure that Fossils is in your list right? It feels great to hear from you.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
Ya.. I like both of them even many more in the list.
Keep in touch.
|
|
|
|