|
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.
|
|
|
|
|
this is the code of my .aspx file
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<br />
<br />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><br />
<br />
<asp:ScriptManager ID="ScriptManager2" runat="server"/>
<asp:Timer ID="Timer2" runat="server" Interval="5000"/>
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<Triggers>
<asp:AsyncPostBackTrigger ControlID="Timer2" EventName="Tick" />
</Triggers>
<asp:AdRotator ID="AdRotator2" runat="server" AdvertisementFile="~/AdRotatorFiles.xml" KeywordFilter="small">
</asp:AdRotator>
<ContentTemplate>
</ContentTemplate>
</asp:UpdatePanel>
</div>
</form>
</body>
</html>
and in the .cs file i have written the following code.
protected void Timer2_Tick(object sender, EventArgs e)
{
UpdatePanel2.Update();
Label1.Text = "Done";
}
thanks in advance
|
|
|
|
|
have you placed that addrotator exectally inside the update panel do check it..
when you drag and drop the controls at design time some times it place the control outside...
Government Dyal Singh College Lahore.
|
|
|
|
|
the ad rotator is exactly inside the update panel yet it is not working. can you provide me the code for it.
thanks in advance.
|
|
|
|
|
this is the code of my .aspx file
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<br />
<br />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><br />
<br />
<asp:ScriptManager ID="ScriptManager2" runat="server"/>
<asp:Timer ID="Timer2" runat="server" Interval="5000"/>
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<Triggers>
<asp:AsyncPostBackTrigger ControlID="Timer2" EventName="Tick" />
</Triggers>
<asp:AdRotator ID="AdRotator2" runat="server" AdvertisementFile="~/AdRotatorFiles.xml" KeywordFilter="small">
</asp:AdRotator>
<ContentTemplate>
</ContentTemplate>
</asp:UpdatePanel>
&nbsp;</div>
</form>
</body>
</html>
and in the .cs file i have written the following code.
protected void Timer2_Tick(object sender, EventArgs e)
{
UpdatePanel2.Update();
Label1.Text = "Done";
}
thanks in advance
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
