|
maheshsahini wrote: ow can i increase the size of my content page, so that the footer always comes at the bottom of the page where the content page ends.
I will suggest, use fix size DIV and place all other content inside the DIV. 
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
following is the code:
Dim constr As String
constr = "Data Source=YOGESH\SQLEXPRESS;Initial Catalog=projdb;Integrated Security=True"
Dim conn As New SqlConnection(constr)
Dim cmd As New SqlCommand(constr, conn)
Dim rd As SqlDataReader
cmd.CommandText = "select * from employee where emp_name='txtname.text'"
conn.Open()
Try
rd = cmd.ExecuteReader()
GridView1.DataSource = rd
GridView1.DataBind()
Catch ex As Exception
MsgBox("exception occured:", MsgBoxStyle.Critical)
MsgBox.show(ex.Message, MsgBoxStyle.Critical)
End Try
basicallly iam tryin to fetch the details of the employee whose name is entered in the textbox of the form, from the database and display the same in a gridview
so after entering the name when i click the submit button an exception stating"exception occured" is gettin displayed..
plzzzzz suggest the changes..
|
|
|
|
|
yorockk wrote: Dim rd As SqlDataReader
cmd.CommandText = "select * from employee where emp_name='txtname.text'"
conn.Open()
Try
rd = cmd.ExecuteReader()
GridView1.DataSource = rd
GridView1.DataBind()
Problem is here. Use Data Set as a source of GridView,which will be very easy for your to display.
Try something like this 
SqlDataAdapter da = new SqlDataAdapter(commandText, ConnectionString);
DataSet ds = new DataSet();
da.Fill(ds)
GridView1.DataSource=ds;
Note : This is C# syntax 
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
me doin project in asp.net using V.B instead of C#
but still i implemented ur idea and made the changes accordingly..but still an exception is gettin occured..
so dis is the updated code:
Dim constr As String
constr = "Data Source=YOGESH\SQLEXPRESS;Initial Catalog=projdb;Integrated Security=True"
Dim conn As New SqlConnection(constr)
Dim cmd As New SqlCommand(constr, conn)
cmd.CommandText = "select * from employee where emp_name='txtname.text'"
Dim da As New SqlDataAdapter(cmd.CommandText, constr)
Dim ds As New Data.DataSet()
conn.Open()
Try
da.Fill(ds)
GridView1.DataSource = ds
Catch ex As Exception
MsgBox("exception occured")
End Try
plzzz suggest the changes for V.B code..
thanx for ur reply..
|
|
|
|
|
Here is my 6 line of Sample Code.
SqlConnection con = new SqlConnection("Data Source=ServerName;Initial Catalog=DBNAME;User ID=sa; password=Password@123");
SqlDataAdapter da = new SqlDataAdapter("select * from TableName", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
And its working fine.
Just Change the Bold section and try to run. And I will suggest you to read some books on ADO.NET, you need to learn some basic of it and also about Connection Less and Connection oriented mode of ADO.NET.
Cheers !!
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
abhijit,
thanx for the reply..
i will surely refer online ebooks on ado.net
|
|
|
|
|
I do not get why people have not caught that sooner, but your SQLString will never take txtname's text into consideration, just the actual string 'txtname.text'.
I'm not at all proficient with vb, but i'm pretty sure, if you wanted to pass user input data as part of your where clause you would have to do:
cmd.CommandText = "select * from employee where emp_name='"+txtname.text+"'"
I do suggest you use parameterized queries or stored procedures instead to avoid sql injection.
Otherwise, if somebody puts "0--;delete from employee" or something of that sort, you're screwed.
To use parameters in your queries, set the command first and then add the parameters, like so:
cmd.CommandText = "select * from employee where emp_name=@empname";
cmd.Parameters.Add("@empname", SqlDbType.NVarChar,50).Value = txtname.text;
I still do advise using stored procedures.
Regards,
Greg
var question = (_2b || !(_2b));
|
|
|
|
|
hey greg ,thanx a lot for the corrections suggested.
i did the corrections and now my code is working fine.
|
|
|
|
|
In mah case an exception was gettin occured "The datatypes text and varchar are not compatible in the equal to operator"
the where condition in the query was
where emp_name='"+txtname.text+"'
so i change the datatype of emp_name from text to varchar(MAX)in the database table..
|
|
|
|
|
hi,
i am using datalist to display my data, bt the problem is i am not able to do paging in it. i checked it on google bt the code was nt clear . so can some one please help???
|
|
|
|
|
maheshsahini wrote: i checked it on google bt the code was nt clear . so can some one please help???
is it.
I have searched and got first link Paging in DataList[^]
and Rest Are[^]
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
I think you might have written some javascript on client end to validate and it all the time gets false and stop the client to do postback because the postback method is also javascript
|
|
|
|
|
i have the current senario........
i have designed a masterpage in asp.net. When referencing it in the content page using
asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
the post back is not working .
please help
thanks
viit.projectgroup
|
|
|
|
|
viit.projectgroup wrote: the post back is not working .
What do you mean by post back is not working ?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
What is the exact problem...?
|
|
|
|
|
want to Display Upper Case Letters in Text Box while Pressing Lower Case Letters, I tried with
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii >= 65 And KeyAscii <= 122 Then
Text1.Text = UCase(Text1.text)
End If
End Sub
but it is printing in reverse , is there any other mothods.
|
|
|
|
|
pramod2517 wrote: want to Display Upper Case Letters in Text Box while Pressing Lower Case Letters, I tried with
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii >= 65 And KeyAscii <= 122 Then
Text1.Text = UCase(Text1.text)
End If
End Sub
I am sure that your are not doing it in ASP.NET. 
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
iam writing code in windows application
|
|
|
|
|
pramod2517 wrote: iam writing code in windows application
Ya.. you code already says that. 
This is ASP.NET Forum, Please post it to C# forum.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hi Pramod
You can try this
"set a css style and use text-transform:uppercase in the rule to display uppercase in the web site - regardless of the text entered"
<html>
<head>
<style >.changecase{text-transform:uppercase ;}</style>
</head>
<body>
<form id="formSample" runat="server">
<asp:TextBox ID="txtUppercase" runat="server" class="changecase"> </asp:TextBox>
</form>
</body></html>
|
|
|
|
|
ok its successfully working.But i want windows application
|
|
|
|
|
There is a property of textbox in window application CharacterString=Upper
pls try it and then reply
Thank You
|
|
|
|
|
hi, i m developing a web system. i want to flash some news where i want only the news to be refreshed and not the whole page. i tried using add rotator along with ajax control i.e update panel, but still it is not working. can anyone provide me the code to do the same.
|
|
|
|
|
Well, AJAX is the only way to do it, unless you put the ad rotator in an iframe.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
can you provide me the code please.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
