Re: Database Exception - ASP.NET Discussion Boards

Re: Database Exception

Michael Sync3-Jan-08 20:08

Michael Sync

3-Jan-08 20:08

SreejithAchutan wrote:
Is the data in a table with datatype image is editable in database.

Not editable. You can't edit it manually. You probably need to use the SQL statement..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: Database Exception

SreejithAchutan3-Jan-08 20:10

SreejithAchutan

3-Jan-08 20:10

I tried it using sql update command itself ,then also an exception of string or binary data truncated is occured.

Re: Database Exception

Michael Sync3-Jan-08 20:50

Michael Sync

3-Jan-08 20:50

Can you please show us the code for updating the image column? so, we can figure out what wrong in your code?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: Database Exception

SreejithAchutan3-Jan-08 21:39

SreejithAchutan

3-Jan-08 21:39

public void UpdateUnitDetails(int UnitId, string UnitName, string UnitShortName, string Location, string UnitLogoPath, string UnitStream, string MaxStudentsPerClass, string LastModifiedByUser)
{
string sqlstatement;
Boolean isUpdated;
try
{
sqlstatement = "UPDATE Units SET UnitName='" + UnitName + "',UnitShortName='" + UnitShortName + "',Location='" + Location + "',UnitLogoPath='" + UnitLogoPath + "',UnitStream='" + UnitStream + "',MaxStudentsPerClass='" + MaxStudentsPerClass + "',LastModifiedByUser='" + LastModifiedByUser + "' WHERE UnitId='" + UnitId + "'";
isUpdated = dbtObj.ExecuteSqlCmd(sqlstatement);
}
finally
{
}
}

protected void btnModify_Click(object sender, EventArgs e)
{
MembershipUser MU;
int UnitId;
string ID;
try
{
MU = Membership.GetUser();
string LastModifiedByUser = MU.UserName;
ID = Gdv_Unit_List.SelectedDataKey.Value.ToString();
UnitId = int.Parse(ID);
Gdv_Unit_List.Columns[0].Visible = true;
string logo = insunit.UploadUnitLogo(UnitId);
if (logo != "")
{
insunit.UpdateUnitDetails(UnitId, Txt_UnitName.Text, Txt_ShortName.Text, Txt_Location.Text, Upload_Logo.FileName.ToString(), DdlStreamList.SelectedItem.ToString(), TxtStdperClass.Text, LastModifiedByUser);
}
else
insunit.UpdateUnitDetails(UnitId, Txt_UnitName.Text, Txt_ShortName.Text, Txt_Location.Text, Upload_Logo.FileName.ToString(), DdlStreamList.SelectedItem.ToString(), TxtStdperClass.Text, LastModifiedByUser);
Gdv_Unit_List.Columns[0].Visible = false;
BindGrid();

}
finally
{
}
}

Thsi is the code .

Re: Database Exception

Michael Sync3-Jan-08 21:54

Michael Sync

3-Jan-08 21:54

SreejithAchutan wrote:
public void UpdateUnitDetails(int UnitId, string UnitName, string UnitShortName, string Location, string UnitLogoPath, string UnitStream, string MaxStudentsPerClass, string LastModifiedByUser)
{
string sqlstatement;
Boolean isUpdated;
try
{
sqlstatement = "UPDATE Units SET UnitName='" + UnitName + "',UnitShortName='" + UnitShortName + "',Location='" + Location + "',UnitLogoPath='" + UnitLogoPath + "',UnitStream='" + UnitStream + "',MaxStudentsPerClass='" + MaxStudentsPerClass + "',LastModifiedByUser='" + LastModifiedByUser + "' WHERE UnitId='" + UnitId + "'";
isUpdated = dbtObj.ExecuteSqlCmd(sqlstatement);
}
finally
{
}
}

What is the code for updating the image? Are you updating the path of image (string) or image (bytes)?

The code below is for updating the image column ... (Note: I typed just like that so you may need to fix some syntax errors but you can get the idea from that code. )

<br />
byte[] img = /// Your image wil come here..<br />
<br />
SqlCommand update = new SqlCommand("UPDATE Person SET ImageColumn = @image<br />
WHERE personalID = " + pID, con);<br />
<br />
SqlParameter imageParameter = update.Parameters.Add("@image",<br />
SqlType.Image);<br />
imageParameter.Value = img;<br />
imageParameter.Size = img.Length;

Hope it helps..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: Database Exception

Paul Conrad4-Jan-08 6:52

Paul Conrad

4-Jan-08 6:52

OT: Your code for the sql statement is a sql injection attack waiting to happen. It's best not to use string concatenation, but rather use parameterized queries for safer coding. Read the SQL Injection Attack article on this site by Colin Mackay.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Re: Database Exception

SreejithAchutan3-Jan-08 21:49

SreejithAchutan

3-Jan-08 21:49

Actually we can modify obnly once .if we try to modify next time then an error had occured.What is the reason."The error is String or Binary is truncated".Is this is due to database design.lz help me

Re: Database Exception

SreejithAchutan3-Jan-08 22:28

SreejithAchutan

3-Jan-08 22:28

I cahnge the image into byte and save and also when modifying the image will be converted.But the pbm occurs only once we can modify the data.when we tried to modify next time an exception occurs.What is the pbm is the pbm in table design.plz help me.

update button in grid view

Sonia Gupta3-Jan-08 19:53

Sonia Gupta

3-Jan-08 19:53

CODE UNDER ROW BOUND DATA IN GRIDVIEW
Button b = (Button)e.Row.FindControl("update");
if (b != null)
{
string str = ChangeDateFormat(DataBinder.Eval(e.Row.DataItem, "indate").ToString());
b.Attributes.Add("onclick", "return abc(" + str.ToString() + ");");
}

CODE IN THE JAVA SCRIPT FUNCTION

function abc(s)
{
alert(s);

return false;
}

Function Defenition
public string ChangeDateFormat(string t)
{
string dat = "";
DateTime datformat;
if (DateTime.TryParse(t, out datformat))
{
dat = datformat.ToString("dd/MM/yyyy");
return dat;
}
return dat;
}
now when i click at the upDATE BUTTON TO CHECK THE VALUE IT GIVES
6576576575757657657
ACTUALLY IT SHOULD GIVE THE DATE IN DD/MM/YYYY FORMAT 12/12/2000.

I HAVED DEBUGGED THE CODE .IT IS SENDIG THE ACCURATE DATE.

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Re: update button in grid view

Michael Sync3-Jan-08 19:57

Michael Sync

3-Jan-08 19:57

Sonia Gupta wrote:
I HAVED DEBUGGED THE CODE .IT IS SENDIG THE ACCURATE DATE.

DON'T SHOUT. OKAY??

Sonia Gupta wrote:
I HAVED DEBUGGED THE CODE .IT IS SENDIG THE ACCURATE DATE.

So, what? Are you asking the question or just wanted to let us know that you have debugged the code?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: update button in grid view

Sonia Gupta3-Jan-08 20:10

Sonia Gupta

3-Jan-08 20:10

Sir, if u don;t want to reply , fine , No Problem , Y r u behaving so rudely.
All i am trying to say , is that , up to this level , i have achieved a particular task , now i am unable to solve it further.
and Sir , as far as the duplicate post is concerned , sir it is lying in the third page .
If u are so concerned with these duplicate posts , sir , i am very eager for ur reply , there in the third page
Thank You Sir

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Re: update button in grid view [modified]

Michael Sync3-Jan-08 20:20

Michael Sync

3-Jan-08 20:20

Sonia Gupta wrote:
Sir, if u don;t want to reply , fine , No Problem , Y r u behaving so rudely.

Sonia, As you are in this forum for long time, you might probably read my reply for other.. So, you might know how I reply.. but you are the one who started shouting in our forum.. Typing in capital is considered as very rude.. but you are asking the question in very rude way..

Sonia Gupta wrote:
sir it is lying in the third page .

I can understand this. but what I want to say is that you should at least reply his post.. Because he is also the one who is trying to help you..

So,

- Don't shout here (typing in capital letters)
- Don't forget to reply any post that replied to your question..

Thank you too..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

modified on Friday, January 04, 2008 3:26:05 AM

Re: update button in grid view

Sonia Gupta3-Jan-08 20:24

Sonia Gupta

3-Jan-08 20:24

Michael Sync wrote:
but you are the one who start shouting in our forum

What's the meaning of this line.Have u purchased the code project site ?????????????
Congratulations!!!!!!!!!

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Re: update button in grid view

Michael Sync3-Jan-08 20:48

Michael Sync

3-Jan-08 20:48

Sonia Gupta wrote:
Have u purchased the code project site ?????????????

Did I say that I bought CP? What I was saying is that you are the one who started shouting here. Oh, btw, what is the difference between "my" and "our"?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: update button in grid view

Sonia Gupta3-Jan-08 20:55

Sonia Gupta

3-Jan-08 20:55

Sir, May i advice u that whenever u feel tired , please take some rest or have some outing.
Be Happy
Cheers.... Smile | :)

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Re: update button in grid view

Michael Sync3-Jan-08 21:03

Michael Sync

3-Jan-08 21:03

Okay. Sonia. Thanks. Good luck!

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Michael Sync3-Jan-08 20:05

Michael Sync

3-Jan-08 20:05

Why don't you reply to his post??
Re: PROBLEM IN UPDATE BUTTON OF GRIDVIEW[^]

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: update button in grid view

janet20083-Jan-08 21:15

janet2008

3-Jan-08 21:15

cease-fire cease-fire
Sonia the fault is yours. Play nice...

Re: update button in grid view

N a v a n e e t h3-Jan-08 22:10

N a v a n e e t h

3-Jan-08 22:10

Sonia Gupta wrote:
I HAVED DEBUGGED THE CODE .IT IS SENDIG THE ACCURATE DATE.

Which is sending the accurate date ? ChangeDateFormat() method ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: update button in grid view

Sonia Gupta3-Jan-08 22:30

Sonia Gupta

3-Jan-08 22:30

Yes

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Columns Width

~V~3-Jan-08 19:44

~V~

3-Jan-08 19:44

Hi all,

I m newbie to asp.net(vb), I have a grid view with 2 columns i tried to set the with of each column using ItemStyle.Width property but it didn't work. Mad | :mad:

Can anyone tell me how can i set the width of column???????????????
Thanks with anticipation Smile | :)

Regard
~V~

Re: Columns Width

Michael Sync3-Jan-08 19:54

Michael Sync

3-Jan-08 19:54

Setting the width of Gridvew

- Go to the designview
- Go to the propertypad of Gridview.
- Click on "Columns"
Ob: Fields dialog will be shon.
- Check "Selected fields" (I think there will be two columns as you said.)
- Click on one of those columns.
- Go to ItemStyle and set something to Width property of ItemStyle.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: Columns Width

~V~3-Jan-08 19:58

~V~

3-Jan-08 19:58

Thanks for your reply, Laugh | :laugh:

I have done same thing as u told me but the itemstyle.width property is not working Mad | :mad:

Re: Columns Width

Michael Sync3-Jan-08 20:02

Michael Sync

3-Jan-08 20:02

then, write one CSS class and assign this CSS class in "CssClass" property of BoundField properties.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: Columns Width

~V~3-Jan-08 20:09

~V~

3-Jan-08 20:09

Sir,
I m newbiew to asp.net so can u provide me some link or other help

Thanks once again

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.