Thank u 4 your post. I fixed my problem..Thank u all...

CheeN

Thank you friend..i fixed that problem.using follwing codes string result="select name,address,age/2 as nAge"; On my GridView1 I set my DataField ='nAgew' Then its all right... Thank you all of you to Guide me to fixed that problem....

CheeN

hey i fixed that prob...thank you bude rly thank......

CheeN

Thank you for you reply .....But i had a problem when i going to DataBind. this is the error.. GridView1.DataBind(); //------ error - A field or property with the name 'age' was not found on the selected data. But i correctly configured on GridView1.I use a BoundField to view this 'age' with DataField='age'on my GridView1 control.. Why i got this error..????

CheeN

Hi All, i want to edit DataSet value before binding to GridView. How can i do that..? conn.open(); string result="select name,address,age"; sqlCommand cmnd=new sqlCommand(result); sqlDataAdapter ad=new sqlDataAdapter(result,conn); DataSet ds=new DataSet(); result.Connection=conn; ad.SelectCommand=result; // in here i want to edit (divide age value by 2) before bind data to gridview. ad.fill(ds); GridView1.DataSource=ds; GridView1.DataBind(); conn.close(); i want to divide age value by 2 before bind data to gridview.How can i do that...??? Thank you very much .....

CheeN

Hi All, i want to edit DataSet value before binding to GridView. How can i do that..? conn.open(); string result="select name,address,age"; sqlCommand cmnd=new sqlCommand(result); sqlDataAdapter ad=new sqlDataAdapter(result,conn); DataSet ds=new DataSet(); result.Connection=conn; ad.SelectCommand=result; // in here i want to edit (divide age value by 2) before bind data to gridview. ad.fill(ds); GridView1.DataSource=ds; GridView1.DataBind(); conn.close(); i want to divide age value by 2 before bind data to gridview.How can i do that...??? Thank you very much .....

CheeN

Friendz, 1)How to write SQL connectionString on web.config file using c#? 1)And how i call that connectionString to my webApplication?

CheeN

Friendz, 1)How to write SQL connectionString on web.config file using c#? 1)And how i call that connectionString to my webApplication?

CheeN

can u post again with how i read it from my web application and how i open that connection @ several times..? thanks alot...

CheeN

$user="UsernameForYourMySqlDB"; $pass="PasswordForYourMySqlDB"; $db="YourDB_Name"; $link=mysql_connect("localhost",$user,$pass); if(!$link) die("Couldnt connect to MySQL"); mysql_select_db($db,$link) or die ("couldnt open $db: ".mysql_error()); print "connected to $db";

CheeN

1. How to store "connection string" in global.asax file and web.config file using c#? 2) How to get that "connection string" from web.config file and global.asax file to My web application? 3)Where i have to call that connection string on My web application and how i call to that connection from My web application..?

CheeN

1. How to store "connection string" in global.asax file and web.config file using c#? 2) How to get that "connection string" from web.config file and global.asax file to My web application? 3)Where i have to call that connection string on My web application and how i call to that connection from My web application..?

CheeN

How to write the SQL DB connection string in namespace file.Then i wanna add that connection string like "using DBconn;" <<DbConn should be connection string>> If you know that how to write DB Connection string using webconfig file also welcome. BD is MSSQL 2005 Programing language : C# Web development using ASP.Net If some one know please reply me Thank you..!!! ReGRdZZZ

CheeN

How to write the SQL DB connection string in namespace file.Then i wanna add that connection string like "using DBconn;" <<DbConn should be connection string>> If you know that how to write DB Connection string using webconfig file also welcome. BD is MSSQL 2005 Programing language : C# Web development using ASP.Net If some one know please reply me Thank you..!!! ReGRdZZZ

CheeN

Thankx $herin...REally thankx... :) i got it....wow....wwww

CheeN

This is my Login Page URL http://localhost:3271/NocSystem/LoginPage.aspx This is my Admin(Home)Page URL http://localhost:3271/NocSystem/AdminPage.aspx If i copy & paste the home pages URL with another Browser it is loading.I want to avoid that.Because if one of user got that URL he can easily access to my web base system through my web server.I'm developing this system to run @ my office's web server. If one of user copy and paste that URL i wanna redirect to my Login Page.How can i do that...?

CheeN

This is my Login Page URL http://localhost:3271/NocSystem/LoginPage.aspx This is my Admin(Home)Page URL http://localhost:3271/NocSystem/AdminPage.aspx If i copy & paste the home pages URL with another Browser it is loading.I want to avoid that.Because if one of user got that URL he can easily access to my web base system through my web server.I'm developing this system to run @ my office's web server. If one of user copy and paste that URL i wanna redirect to my Login Page.How can i do that...? Its urgent..!!!

CheeN

This is my Login Page URL http://localhost:3271/NocSystem/LoginPage.aspx This is my Admin(Home)Page URL http://localhost:3271/NocSystem/AdminPage.aspx If i copy & paste the home pages URL with another Browser it is loading.I want to avoid that.Because if one of user got that URL he can easily access to my web base system through my web server.I'm developing this system to run @ my office's web server. Its urgent..!!!

CheeN

Can i use regular expression or any validater?If yes how can i use that..? i tried Match MatchTelNum = Regex.Match(tel.Text, "[a-z&0-9]*"); Its wroks.But i had a problem coz if i entered "3333333" to that textBox1.It also giv an error message.If you can help me.. ReagrDzzz

CheeN

I wanna allow only number for my TextBox1.Its can only insert 7 digits.If I enter "23ddddd" on my TextBox1 i wanna give an error message for that.So please help me...........

CheeN