Hi I want to pass a column value of datagrid from form1 to form2. It is not passing the value. can anyone help me to solve this issue. the column has to display only text join, but it has to pass the databasevalue. following is the code. DataTable dt = new DataTable(); DataRow dr; DataView dv; if (dbReader != null) { dt.Columns.Add(new DataColumn("Join" , typeof(string))); while (dbReader.Read()) { dr = dt.NewRow(); StringBuilder strTop = new StringBuilder(""); strTop.Append(ShowImageNew(dbReader)); strTop.Append("
"); strTop.Append("

"> strTop.Append(""); dr[0] = "

[Join](joinInGroup.aspx?Category =)

"; dt.Rows.Add(dr); } } thanks

Hi How to set data grid pager style numeric as well as NextPrev for single data grid. I have to set both style for single dat grid. Thanks

Thanks

hi, <-- dr[1] = "

Join

"; --> dr[1] = "

Join

"; in the above statement, i am passing value group.aspx page, there i am using Request.QueryString["GroupName"]; to get this value. the problem is the value is not passing to Group.aspx page, what is wrong in my code. any one help me to solve this problem. thanks

Below is the code. I want to format the date column of data grid like "13,January 1900". i know DataFromatString = "{0:d}" for bound column. I am creating column dynamically. could anyone help to solve this issue. private DataView CreateDataSourceSourceWise() { string strSQL; string connstring = HttpContext.Current.Application["connstring"].ToString(); SqlConnection readConnection = new SqlConnection(connstring); SqlDataReader dbReader = null; int nUID = Convert.ToInt32(Session["UID"]); string CaName = Request.QueryString["CategoryName"]; strSQL= "select Description,CategoryName,GroupName,GroupImage,CreatedDate from group where ((UserID= '" + nUID + "') and ( CategoryName = '" + CaName + "' ))"; SqlCommand readCommand = new SqlCommand(strSQL,readConnection); readCommand.Connection.Open(); dbReader = readCommand.ExecuteReader(); DataTable dt = new DataTable(); DataRow dr; DataView dv; if (dbReader != null) { dt.Columns.Add(new DataColumn(Request.QueryString["CategoryName"])); dt.Columns.Add(new DataColumn("Join" , typeof(string))); dt.Columns.Add(new DataColumn("Members" , typeof(string))); dt.Columns.Add(new DataColumn ("DateCreated")); while (dbReader.Read()) { dr = dt.NewRow(); StringBuilder strTop = new StringBuilder(""); strTop.Append(ShowImageNew(dbReader)); strTop.Append("
"); strTop.Append(""); strTop.Append("

"); strTop.Append(Convert.ToString(dbReader["GroupName"])); strTop.Append("
"); strTop.Append("    "); strTop.Append(Convert.ToString(dbReader["Description"])); strTop.Append("

"); dr[0] = strTop.ToString(); dr[1] = "

Join

"; dr[2] ="

" + dbReader["CategoryName"].ToString() +"

"; string strlink =" []( + Convert.ToString(dbReader[)"; dr[3] ="

" + dbReader["CreatedDate"] +"

"; dt.Rows.Add(dr); } } else { Response.Write(("No Groups were created for this Category") + Request.QueryString["CategoryName"]);

Hi, I have the datagrid,it is working fine. the problem is i am passing single value from another page to this data gird page. I want to set that value as a column header value for that data grid. thanks.

I have used the following code. but still i couldnt diaplay the image, it shows the text System.Byte[] in that column. here is the code try { string Category = Request.QueryString["UserID"]; SqlConnection myConn = new SqlConnection("server=localhost;uid=sa;pwd=;database=BzzzNet"); SqlCommand myCommand = new SqlCommand("perustorproc", myConn); myCommand.CommandType = CommandType.StoredProcedure; myConn.Open(); DG_Persons.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection); DG_Persons.DataBind(); } catch (SqlException ex) { throw new Exception(ex.ToString()); } finally { } --------------- can any one help me to solve this problem. thanks

Hi, How to display images in the datagrid column i am using Asp.net using c#. I am looking code sample or article. Help will be greatly appriciated. Thanks

still it is not working. i am sending the full code. after passing the value, i am stroing the image file in sql server 2000 database. -------------- public void UploadBtn_Click(object sender, System.EventArgs e) { if (Page.IsValid) { Stream imgStream = UploadFile.PostedFile.InputStream; int imgLen = UploadFile.PostedFile.ContentLength; string imgContentType = UploadFile.PostedFile.ContentType; byte[] imgBinaryData = new byte[imgLen]; int n = imgStream.Read(imgBinaryData,0,imgLen); int RowsAffected = SaveToDB( imgBinaryData); if ( RowsAffected>0 ) { Response.Write("
The Image was saved"); } else { Response.Write("
An error occurred uploading the image"); } } } private int SaveToDB(byte[] imgbin) { try { caName = Request.QueryString["CategoryName"]; grName = Request.QueryString["GroupName"]; SqlConnection connection = new SqlConnection "server=localhost;pwd=;userID=sa;data source=test"); Response.Write(caName); Response.Write(grName); SqlCommand command = new SqlCommand("Update BZZZ_Bzzzrings_Group set GroupImage = '" + imgbin + "' WHERE UserID = " + nUID + " AND CategoryName = '"+ caName +"' AND GroupName = '" + grName +"'",connection); connection.Open(); int numRowsAffected = command.ExecuteNonQuery(); connection.Close(); return numRowsAffected; } catch (SqlException ex) { throw new Exception(ex.ToString()); } finally { } }

I have dropdownlist control and text box control. I passsing this dropdownlist control and text box control values to another page, there i using request.querysting to get the parameter. but nothing is dipalying when i try to print. page1 Response.Redirect("testing.aspx?CategoryName = drlstCountry.SelectedItem.Text & GroupName = txtGroupName.Text",true); page2 string caName; string grName; caName = Request.QueryString["CategoryName"]; grName = Request.QueryString["GroupName"]; i am using c# , can anyone help me. thanks

if right click over the folder then i slected the properties, it shows General,sharing, websharing, customize tabs only,not view tab. how to i open the folder options dialog. Thanks & regards

Hi I have created asp.net application in windows XP Inetpub/wwwroot/.. i have created a folder in that application to store the images. but i am getting this error. To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.' i checked properties of the pages, i couldnt find anything like security tab. i am not ruuning this application in IIS, i am running this application in windows XP under c:/Inetpub/wwwroot/application1. can anyone help to resolve this issue. help will be greatly appriciated. thanks

Thanks. both ideas or working. i greatly appriciate.

Hi, I have two dropdown list control, one has all the country values (USA,India,Japan etc.,) and another dropdown list control has a value of states ( CA,MA,WA,MD etc.,). i have one textbox to enter states name for non USA. if i select country as USA then the state dropdown list control should be enabled and the txtbox should be diabled. if i select country as othen then USA the state dropdown list control should be disabled and the txtbox should be enabled. how to achive this can anyone help Thanks Perumal Sethuraman

;' Runat=server> <%# DataBinder.Eval(Container,"DataItem.CategoryName" ) %> i want pass the datalist value to another page. i am geeting error. how to solve this problem. anyone help me. Thanks

i have populated the data in the datalist control. if i click that data, it has to pass that value to another page how can i do this. any one help me. thanks

how to bind two query results with single daltalist. Help will be greatly appriciated. Thanks

Hi SuzyB, Ketty I tried with DataList Control,now it is working fine. I appriciated your Idea/help. Thanks.

hi SuzyB, i want to display the results in two columns of table equally, but i am picking up single column ofdata from back end. i have display euqally in two columns. for example the data i am picking up is 1,2,3,4,5,6,7,8,9,10,11,12. i want to display 6 in onecolumn and another 6 in one coulmn of the table. can u sent some code or link or idea thanks SuzyB

i am retreving data from sqlserver 2000 table.it has only one column. i want to display those record in a table in two column. for example, if it is 100 records, i want to display in equally 50:50 in two columns of a table. i need any idea or code . help will be greatly appriciated. thanks :((