|
Sneha,
Here a very good article from Samir, Hope this will help you.
Click Here[^]
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hi all,
I have a web page which i don't want to disclose to the user, the response of this is a file download dialogue....
And by using web request and web response objects im calling that above web page and getting the response but my problem is im getting only the file type and the content but actually i want content.
So please help me if you know..........
thanks in advance
Lakshmi
|
|
|
|
|
blakshmi wrote: And by using web request and web response objects im calling that above web page and getting the response but my problem is im getting only the file type and the content but actually i want content.
Problem is not clear to me.  can you please be little bit clear
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Here's the deal!
I'm creating two drop down lists dynamically in a GridView control and populating the second dropdownlist(let's call it ddl2 from now on) on the basis of the selection on the first dropdownlist control. The crisis is that, for multiple rows on the gridview the ddl2 starts appending values to itself and therefore ends up having repeats of the data it should originally hold.
How do I stop this repeat from happening? My code is as below.
<asp:GridView ID="grd" runat="server" OnRowDataBound="grd_RowDataBound">
<Columns>
<asp:TemplateField HeaderText="names">
<ItemTemplate>
<asp:DropDownList ID="name" runat="server" OnSelectedIndexChanged="onSelectChangeddl"></asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="age">
<ItemTemplate>
<asp:DropDownList ID="age" runat="server" AutoPostBack="true">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
In c# code, i am trying to change the values of the second drop down list based on the value selected in the first. I am doing this as below:
foreach (GridViewRow row in grd.Rows)
{
DropDownList ddl1 = (DropDownList)row.FindControl("name");
DropDownList ddl = (DropDownList)row.FindControl("age");
if (ddl.SelectedValue.ToString() != "---Select---")
{
}
else
{
ddl.Items.Clear();
}
SqlCommand SPComm = new SqlCommand("someStoredProcedure", myConn);
SPComm.CommandType = CommandType.StoredProcedure;
SqlParameter param = SPComm.Parameters.Add("@something", SqlDbType.NVarChar, 50);
param.Value = something;
dr = SPComm.ExecuteReader();
int i = 0;
while (dr.Read())
{
ddl.Items.Insert(i, dr.GetString(0));
}
dr.Close();
ddl.Items.Insert(0, "---Select---");
}
In the above code, all the values in the second drop down list are getting duplicated based on the selected index changed event handler of the first drop down list.
Can anyone help me with this? Been trying all kinds of stuff with this since three weeks now! H-e-L-p!
scarface
|
|
|
|
|
hi,
In my website when m displaying my data in a datalist. the list is so long that it is overlapping with my footer. how 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.
|
|
|
|
|
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>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
