|
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.
|
|
|
|
|
Hi....
Actually after login users can upload their resume and they can view it.
For doing this,
step1:when user is uploaded his/her resume,i saved it in server folder named "UserResumes" and at the same i took a copy of this resume and saved it as html file in same folder.
step2: I took a frame in my aspx page and given source.
like Frame["src"]="~/UserResumes/MyResume.htm"
Everything is working fine in local system.I am able to show preview of resume to users.
But the thing is when i hosted the application in EGCG serevr,it is giving following error.
Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80040154.
Could you plz help me out.....................
Thanks,
ravikumar
|
|
|
|
|
Is Word on the server ? Which step creates the error ? What code is the issue, uploading, or viewing ?
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
i have problem with viewing the resume.
word file and html copy of it are getting saved in server folder successfully.And i dont think word is not on the server bocz 99% word will be thre on server
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
