|
Abhishek Sur wrote: Choose appropriate DataTextField and DataValueField.
I guess he is missing bind with DataValueField
|
|
|
|
|
yes... right.
If DataValueField is not specified, the value will be same as DataTextField . I personally always set ID as value so that I could set SelectedValue with some numeric field or GUID , as TextField may repeat.
|
|
|
|
|
thnks for all who reply me .. i tried like this also bu there is no output..
and this is my code
if (!IsPostBack)
{
DataSet ds1 = new DataSet();
ds1 = ad.dsGetvalues("Select * from Countries", true);
ddlCountry.DataSource = ds1;
ddlCountry.DataTextField = "sCountryName";
ddlCountry.DataValueField = "sno";
ddlCountry.Items.Insert(0, "--Select--");
ddlCountry.DataBind();
DataSet dss = new DataSet();
dss = ad.dsGetvalues("select * from UserDetails where PkiUsername ='"+Session["Username"].ToString()+"' ", true);
ddlCountry.SelectedValue = dss.Tables[0].Rows[0]["sCountry"].ToString();
}
try and try untill reach success..
|
|
|
|
|
Rajeshwar Code- Developer wrote: ddlCountry.DataValueField = "sno";
Try this
ddlCountry.DataTextField = "sCountryName";
ddlCountry.DataValueField = "sCountryName";
|
|
|
|
|
I'm using data access class that handles SQL requests and updates to db.
After I added delete, edit buttons in GridView, any clicks returns in error that the RowEditing, Deleting was not handled.
Also how can I update the GridView after I modified the selected row in DB? I use selection to edit that record in another page, and then update DB with custom DB class. How to alert GridView and its DataSet that the record now has different contents?
I tried to use ObjectDataSource for that purpose but it failed to launch reporting ambiguity between ~\bin web project module and the ASP.NET temporary one under windows folder
Чесноков
|
|
|
|
|
|
After the ASP.NET project is put to external server with db in ~\App_Data folder (using SQL 2005 express edition), any updates or insertions of records into db fail with error that DB is read-only.
How to set up it with RW access rights. Or it is due to App_Folder location glitch?
Entire web project folder has RW access setup in IIS
Чесноков
|
|
|
|
|
|
But I never attached the DB in SQLEXPRESS. The App_Data is RW by all means, I'm writing logs into it.
Чесноков
|
|
|
|
|
there is no sseutil.exe either
Чесноков
|
|
|
|
|
How to create name of the website in IIS?
I tried but i can't.
I opened IIS, in DefaultWebSite i right clicked but no option is there for creating new website.
I can see only New,All Task and View in Default website when i right clicked.
I New option i can find New->virtual Directory. Not New->WebSite.
Is there any solution for creating website name?
I am using IIS6.
I tried from http://www.startvbdotnet.com/aspsite/extras/deploy2.aspx[^]
|
|
|
|
|
kavinnagarajan wrote: I New option i can find New->virtual Directory. Not New->WebSite.
Expand Web site Folder, ther yo will find Default Web Site . Right Click on that, you will get, New > Virtual Directory.
let me know if you have any issue
|
|
|
|
|
|
Suresh, I am just few sec late
|
|
|
|
|
|
Hi Abhijit,
You are very helpful person and a greate coder/programmer..
Btw I have preferred the same article...
Thanx
Be an Eagle, Sky is Yours.
|
|
|
|
|
I was few second left
|
|
|
|
|
I got an error like this
Failed to access IIS metabase.
|
|
|
|
|
kavinnagarajan wrote: I got an error like this
Failed to access IIS metabase.
Does you IIS Regsitred with ASP.NET ? Did you installed IIS after installing Visual Studio in you system ?
Please register IIS with ASP.NET as following way,
%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
Then Try it again
This will resolve your problem .
|
|
|
|
|
Its working not fully.
I can able to access pages but i can't able to connect to database & i can't able to perform any operations.
|
|
|
|
|
kavinnagarajan wrote: Its working not fully.
No, Its working fully other wise you will not able to access the web page. That was the problem related with ASP.NET Framework regsitration. And its Resolved now.
kavinnagarajan wrote: but i can't able to connect to database & i can't able to perform any operations.
Did you check you connection string ? Is it valid ? What do you mean by any opertion ? I guess there is wrong with you DB Connections.
Let me know if you have any issue
Thanks !
|
|
|
|
|
I can run it from asp.net developement server but not in from IIS.
I can do all DB operations in asp.net developement server and not in IIS.
|
|
|
|
|
Show me the connection string ? And what exact error you are getting ? Other wise it quite difficult to tell.
|
|
|
|
|
string constring = "Data Source=localhost\\sqlexpress; Initial Catalog=Barani; Integrated Security=SSPI;";
the above is connection string.
try<br />
{<br />
Label3.Text = Label4.Text = "";<br />
Panel1.Visible = false;<br />
con = new SqlConnection(constring);<br />
con.Open();<br />
cmd = new SqlCommand("select * from BoardM", con);<br />
dread = cmd.ExecuteReader();<br />
if (!IsPostBack)<br />
{<br />
DropDownList1board.Items.Add(new ListItem("--Choose Board--", "0"));<br />
while (dread.Read())<br />
{<br />
DropDownList1board.Items.Add(new ListItem(dread["BoardName"].ToString(), dread["BoardId"].ToString()));<br />
}<br />
<br />
enable_disable(false, false, true, true, true, true, false, false);<br />
}<br />
con.Close();<br />
}<br />
catch<br />
{<br />
Page.RegisterStartupScript("My Script", "<script language=javascript>error('Database cannot be opened');</script>");<br />
}
the exception is throwing whe i run in IIS
|
|
|
|
|
kavinnagarajan wrote: the exception is throwing whe i run in IIS
What is that ? Tell me the exact error other wise it will going to be a endless discussion.
|
|
|
|