Comments by Member 11357862 (Top 31 by date)

I have used the above code but its not working

thank u Jeet

I hv used the code, but it shows error her
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;
TextBox3.Text = row.Cells[1].Text;
TextBox4.Text = row.Cells[2].Text;
TextBox5.Text = row.Cells[3].Text;
}
protected void Button2_Click(object sender, EventArgs e)
{
GridView1_SelectedIndexChanged(sender, e)

}
error:null reference exception was unhandled by user code
shows this error on TextBox3.Text = row.Cells[1].Text;

protected void Button2_Click(object sender, EventArgs e)
{
TextBox3.Text = GridView1.Rows[HiddenField1.Value].Cells[1].Text;
TextBox4.Text = GridView1.Rows[HiddenField1.Value].Cells[2].Text;
TextBox5.Text = GridView1.Rows[HiddenField1.Value].Cells[3].Text;
TextBox6.Text = GridView1.Rows[HiddenField1.Value].Cells[4].Text;

}
I have added this on button1, but it shows error. How can I declare the hidden field value?

no its outside the gridview,
I need to add the selected indexchanged event on this button. If I click on the submit button(btn1) then this code want to execute
GridViewRow row = GridView1.SelectedRow;
TextBox3.Text = row.Cells[1].Text;
TextBox4.Text = row.Cells[2].Text;
TextBox5.Text = row.Cells[3].Text;

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.IO;
using System.Collections.Generic;

public partial class Default4 : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data source = VISHNUIT;Initial Catalog = sims1; Integrated security= True");
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
Body.Attributes["bgcolor"] = "apple green";
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;
TextBox3.Text = row.Cells[1].Text;
TextBox4.Text = row.Cells[2].Text;
TextBox5.Text = row.Cells[3].Text;
}
protected void TextBox3_TextChanged(object sender, EventArgs e)
{
String str = "select * from login where (uname like + @search + '%' )";
SqlCommand xp = new SqlCommand(str,con);
xp.Parameters.Add("@search", SqlDbType.VarChar).Value = TextBox3.Text;
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = xp;
DataSet ds = new DataSet();
da.Fill(ds, "uname");
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{

}
}

Here button1 is my submit button.

alter TABLE Mycode12 alter column adescrip nvarchar(max) COLLATE Arabic_BIN
I have used this query, now it shows as ßÑÓì ÍãÇã ÈÚÌáÇÊ

I have added nvarchar, but can't view the Arabic data. In my column already have Arabic script. but it shows as ?CE. cannot able to view it. For inserting new data in Arabic format I can add it by N' Arabic script'. Its working. But I already have some datas in database in Arabic scripts. Can't able to view it.

thank u sir for ur great help

Sir I hve executed the statement but it shows this error.
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

sir I checked my whole pgm, I think that it is due to the convertion error. The image will insert to the code like 110,111 etc. But image will not insert into the code like 110-1,D110-1 etc. How can I resolve this

could u pls explain

No, my current coding is updating, but only for 22 rows remaining not.

No, my current coding is updating, but only for 22 rows remaining not.

no, its on my system

img is my image column in database. in this column I want to insert the images. the path of image is this 'D:\images.

DECLARE @CODE nvarchar(50)
DECLARE image_cursor CURSOR FOR
SELECT CODE FROM MyMast WHERE img IS NULL
OPEN image_cursor;
FETCH NEXT FROM image_cursor
INTO @CODE;
WHILE @@FETCH_STATUS = 1

BEGIN
DECLARE @sql NVARCHAR(MAX)
DECLARE @imagePath NVARCHAR(255)
SET @imagePath = 'D:\images\'+ RTRIM(LTRIM('@CODE')) + '.jpg'
SET @sql = 'UPDATE MyMast '
SET @sql = @sql + 'SET img = (SELECT BulkColumn FROM OPENROWSET( BULK ''' + @imagePath + ''', Single_Blob) AS img) '

SET @sql = @sql + 'WHERE CODE = ''' + (@CODE) +''';';
BEGIN TRY
EXECUTE sp_executesql @sql
END TRY
BEGIN CATCH

END CATCH

FETCH NEXT FROM image_cursor
INTO @CODE;
END
CLOSE image_cursor;
DEALLOCATE image_cursor;

SELECT CODE, img FROM MyMast WHERE img IS NOT NULL

sir, thank u for ur great help, but still it is updating only 22 rows.I my D:\images folder there is images in the name 110-1.jpg,110-2.jpg etc. In my sql table there is the product code 110-2,110-1 etc.

ya done, I think the problem is in any other parts, still hv same issue, is there any code available to insert this image in asp.net using c#?

DECLARE @CODE varchar(20)
DECLARE image_cursor CURSOR FOR
SELECT CODE FROM MyMast WHERE img IS NULL
OPEN image_cursor;

FETCH NEXT FROM image_cursor
INTO @CODE;

WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @sql NVARCHAR(MAX)

DECLARE @imagePath VARCHAR(255)
SET @imagePath = 'D:\images\' + RTRIM(LTRIM(@CODE)) + '.jpg'

SET @sql = 'UPDATE MyMast'
SET @sql = @sql + 'SET img = (SELECT BulkColumn FROM OPENROWSET( BULK ''' + @imagePath + ''', Single_Blob) AS Picture), PictureFileName = ''' + @imagepath + ''' ';
SET @sql = @sql + 'WHERE CODE = ''' + @CODE + ''';'
BEGIN TRY
PRINT @sql

END TRY
BEGIN CATCH

END CATCH

FETCH NEXT FROM image_cursor
INTO @CODE;
END
CLOSE image_cursor;
DEALLOCATE image_cursor;

SELECT CODE, img FROM MyMast WHERE img IS NOT NULL

sir I have done this query correction, but its not updating the remaining coloumns.

I have changed @sql nvarchar(max) and the code to SET @sql = @sql + 'SET img = (SELECT BulkColumn FROM OPENROWSET( BULK ''' +' @imagePath' + ''', Single_Blob) AS Picture),PictureFileName = ' + '@imagepath' but same pblm

ya I hv given space, but it doesn't resolved issue, can u pls give me any other code for inserting multiple images?

ya I have removed the set before the picture file name. I didn't get the details abt string concatenation

I didn't get u

sir till now my issue is not reolved