ASP.NET

How to delete/update GridView using custom data access class

13-Aug-09 23:43

Rajeshwar Code- Developer wrote:
ddlCountry.DataValueField = "sno";

Try this

ddlCountry.DataTextField = "sCountryName";
ddlCountry.DataValueField = "sCountryName";

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Chesnokov Yuriy13-Aug-09 20:54

Re: How to delete/update GridView using custom data access class

13-Aug-09 20:54

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

Чесноков

Vimalsoft(Pty) Ltd13-Aug-09 23:09

Vimalsoft(Pty) Ltd

13-Aug-09 23:09

i have done this with windows application check the Following articles

Coding an N-Tier Application in C# Without Any Wizard: Part II[^]

for web in Gridview

http://www.dotnetfunda.com/articles/article18.aspx[^]

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

DB is read-only error on the server

Chesnokov Yuriy13-Aug-09 20:49

Re: DB is read-only error on the server

13-Aug-09 20:49

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

Чесноков

Abhijit Jana13-Aug-09 20:52

Re: DB is read-only error on the server

13-Aug-09 20:52

This will help you[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Chesnokov Yuriy13-Aug-09 20:59

Re: DB is read-only error on the server

13-Aug-09 20:59

But I never attached the DB in SQLEXPRESS. The App_Data is RW by all means, I'm writing logs into it.

Чесноков

Chesnokov Yuriy13-Aug-09 21:01

13-Aug-09 21:01

there is no sseutil.exe either

Чесноков

kavinnagarajan13-Aug-09 20:34

13-Aug-09 20:34

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[^]

Abhijit Jana13-Aug-09 20:46

13-Aug-09 20:46

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

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Suresh Suthar13-Aug-09 20:48

Suresh Suthar

13-Aug-09 20:48

Hi,

Please read this article. It will help you to configure you web site on IIS.

Deployment of a Website on IIS[^]

Be an Eagle, Sky is Yours.

Abhijit Jana13-Aug-09 20:49

13-Aug-09 20:49

Suresh, I am just few sec late Wink | ;)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Abhijit Jana13-Aug-09 20:48

13-Aug-09 20:48

Here is a good article on deployment
Deployment of a Website on IIS 6.0[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Suresh Suthar13-Aug-09 21:06

Suresh Suthar

13-Aug-09 21:06

Hi Abhijit,
You are very helpful person and a greate coder/programmer..

Btw I have preferred the same article...

Thanx Thumbs Up | :thumbsup:

Be an Eagle, Sky is Yours.

Abhijit Jana13-Aug-09 21:13

13-Aug-09 21:13

I was few second left Laugh | :laugh:

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

kavinnagarajan13-Aug-09 21:07

13-Aug-09 21:07

I got an error like this

Failed to access IIS metabase.

Abhijit Jana13-Aug-09 21:15

13-Aug-09 21:15

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 Big Grin | :-D

This will resolve your problem .

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

kavinnagarajan13-Aug-09 21:30

13-Aug-09 21:30

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.

Abhijit Jana13-Aug-09 21:33

13-Aug-09 21:33

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. Wink | ;)

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 Wink | ;)

Thanks !

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

kavinnagarajan13-Aug-09 21:36

13-Aug-09 21:36

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.

Abhijit Jana13-Aug-09 21:39

13-Aug-09 21:39

Show me the connection string ? And what exact error you are getting ? Other wise it quite difficult to tell.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

kavinnagarajan13-Aug-09 21:44

13-Aug-09 21:44

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

Abhijit Jana13-Aug-09 21:52

13-Aug-09 21:52

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.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

kavinnagarajan13-Aug-09 22:31