|
From my website I am sending Sql Query to a my local machine which is connected in a network , through router.
Thanks for you reply
|
|
|
|
|
manish.m.meshram wrote: I am sending Sql Query to a my local machine which is connected in a network
I am not sure what you exactly mean by "sending SQL Query to a my local machine".
But in general ADO.NET provides all the features using which websites generally interact with SQL Server.
You can take a look into this[^] (still I am sure you are not looking for this simple thing ).
Anyway,let me know if you need something more.
|
|
|
|
|
Hi all,
I have one contactus.html page, and I used shared windows hosting with IIS7 and the service provider is "godaddy.com".But I try to send message I got the following error:
Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Thanks
Denny
|
|
|
|
|
Does your SMTP required Authentication ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
|
This is permission issue...
Just go to the virtual directory and add permission to ASP.NET user.
|
|
|
|
|
Hello all,
I am dynamically creating DropDownList in my application.
While running application, when i select some value in DropDownList it is showing fine, but if i click some other button then DropDownList is always showing its first item.
I heard this happens because of PostBack.
I tried by setting AutoPostBack property to both true and false, but still same problem occuring both time.
Can anyone help me?
Thanks,
Nagendra.
|
|
|
|
|
Check that you are not rebinding the dropdownlist when the button click causes the postback.
only two letters away from being an asset
|
|
|
|
|
This is my code, i am creating DropDownList inside GridView
<asp:TemplateField HeaderText="Item">
<ItemTemplate>
<asp:DropDownList runat="Server" ID="itemCodeList" DataSourceID="SqlDataSource2" DataTextField="ItemLongDesc" DataValueField="ItemCode" AutoPostBack="true" />
</ItemTemplate>
</asp:TemplateField>
|
|
|
|
|
You are using it inside Gridview ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
When did you create those Dynamic control. You have to create the dynamic control before page_load() , other wise that control will not be able to maintain viewstate and Postback datra, cause LoadViewState() and LoadPostbackData() called juts before page_load() .
IF you created control before page_load,
Try to do this in
Page_Load()
if( ! Page.IsPostBack)
{
}
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
i am creating it inseide a GridView
|
|
|
|
|
Is it possible to generate Sitemappath through the database..........if yes then how.......is it relaed to something CustomizeSiteProvider...........plz guide me a bit.........
|
|
|
|
|
|
|
|
Hi,
I have some problem with using variables, I am making a form in C#?asp.net .
Now in my web application form I am having two controls on web page (dropdown, button); depending on the selection in the dropdown I have changed some value in a integer variable.
PROBLEM: the variable retains this value until the event ends.
after that I am using this value to do some processing; it is here that I find that the int value has changed back to 0(its default value). How can I prevent this as I need the value of the int?
I have tried my code both by declaring the int variable as global to that form and also by declaring it inside that particular event.
can someone please help me?
thank You
|
|
|
|
|
Do you have a check of PostBack in the Page_Load?
If not then add that in for Form_Load.
Declare the variable at class level.
Then initialize the variable under if(!Page.IsPostBack) .
|
|
|
|
|
Hi Everybody
i want to know how we will do paging and sorting in gridview in asp.net2.0 with c#.plz help
me soon.
thanks®ards
vivek sachan
|
|
|
|
|
|
|
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string str = "Select * From Vendor Where(VendorID= '"+ DropDownList1.SelectedValue +"')";
OleDbCommand cmd = new OleDbCommand(str, conn);
OleDbDataReader dr=null;
conn.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
txtvendorname.Text = dr["VendorName"].ToString();
}
conn.Close();
}
hi i am getting data type mismatch error on executin this code.plz guide...
|
|
|
|
|
mylogics wrote: data type mismatch error
I have couple of suggestions -
1. Instead of the SELECT * FROM Vendor, use the columnames you need e.g. SELECT VENDOR_NAME,VENDOR_ID FROM Vendor.
2. Instead of dr[columnname] use dr.GetInt32(index) or dr.GetString(index).
See the example here[^].
|
|
|
|
|
the problem is not due to this.i have tried it.....
|
|
|
|
|
Can you put a try catch and find out the trace?
Also in which line you are getting that?
It would be good if you can provide the data types of your table columns as well.
modified on Saturday, August 29, 2009 7:46 AM
|
|
|
|