Click here to Skip to main content
15,893,663 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: retrieve image from database automatically change particular time interval Pin
Michael Sync27-Dec-07 20:59
Michael Sync27-Dec-07 20:59 
GeneralRe: retrieve image from database automatically change particular time interval Pin
Abhijit Jana27-Dec-07 20:43
professionalAbhijit Jana27-Dec-07 20:43 
Generalbinary Pin
niki_nilu27-Dec-07 18:54
niki_nilu27-Dec-07 18:54 
GeneralRe: binary Pin
niki_nilu27-Dec-07 19:17
niki_nilu27-Dec-07 19:17 
GeneralRe: binary Pin
Sonia Gupta27-Dec-07 19:32
Sonia Gupta27-Dec-07 19:32 
GeneralRe: binary Pin
niki_nilu27-Dec-07 20:22
niki_nilu27-Dec-07 20:22 
GeneralRe: binary Pin
Sun Rays27-Dec-07 19:38
Sun Rays27-Dec-07 19:38 
GeneralRe: binary Pin
niki_nilu27-Dec-07 20:43
niki_nilu27-Dec-07 20:43 
hi i am using asp.net 2.0 with c#.
and my database is MSSQL server in that i have tuser table in that
i have password feild which datatype is Binary.

i have following code

strSqlCmdText = "insert into tUser values( " + Convert.ToInt32(txtUserCode.Text) + " , "+
" " + " ' " + txtUserID.Text + " ' " + "," + " ' " + txtFirstName.Text + " ' " + ", "+
" " + " '" + txtLastName.Text + "'" + "," + " ' " + txtPassword.Text + " ' " + ", "+
" " + "'" + txtUserType.Text + "'" + ", "+
" " + "'" + dtpWarningDate.SelectedDate + "'" + " , "+
" " + "'" + dtpExpireDate.SelectedDate + "'" + ", "+
" " + "'" + drpdwnStatus.SelectedItem.Text + "'" + ", "+
" " + "'" + Session["LoginName"].ToString() + "'" + ", "+
" " + "'" + dtpCreateDate.SelectedDate.ToString() + "'" + ", "+
" " + "'" + txtUpDatedBy.Text + "'" + ", "+
" " + "'" + dtpUpdateDate.SelectedDate.ToString() + "'" + ")";

objClsDllSql.funSqlCmd(strSqlCmdText);

when it run that time following error is comming===========

Disallowed implicit conversion from data type varchar to data type binary, table 'eSRS.gayatri.tUser', column 'Password'. Use the CONVERT function to run this query.

pls help me.

Gayatri

GeneralRe: binary Pin
Sun Rays27-Dec-07 20:51
Sun Rays27-Dec-07 20:51 
GeneralRe: binary Pin
niki_nilu27-Dec-07 23:06
niki_nilu27-Dec-07 23:06 
GeneralRe: binary Pin
niki_nilu30-Dec-07 19:21
niki_nilu30-Dec-07 19:21 
GeneralRe: binary Pin
N a v a n e e t h27-Dec-07 21:21
N a v a n e e t h27-Dec-07 21:21 
GeneralRe: binary Pin
Sathesh Sakthivel27-Dec-07 20:04
Sathesh Sakthivel27-Dec-07 20:04 
Questionhow i can i change the tool tip styles Pin
jagan12327-Dec-07 18:38
jagan12327-Dec-07 18:38 
AnswerRe: how i can i change the tool tip styles Pin
Michael Sync27-Dec-07 18:42
Michael Sync27-Dec-07 18:42 
GeneralRe: how i can i change the tool tip styles Pin
jagan12327-Dec-07 19:14
jagan12327-Dec-07 19:14 
GeneralRe: how i can i change the tool tip styles Pin
Michael Sync27-Dec-07 19:27
Michael Sync27-Dec-07 19:27 
AnswerRe: how i can i change the tool tip styles Pin
Abhijit Jana27-Dec-07 20:48
professionalAbhijit Jana27-Dec-07 20:48 
GeneralUnrecognized configuration section 'connectionStrings' Pin
www.Developerof.NET27-Dec-07 17:47
www.Developerof.NET27-Dec-07 17:47 
GeneralRe: Unrecognized configuration section 'connectionStrings' Pin
Michael Sync27-Dec-07 18:41
Michael Sync27-Dec-07 18:41 
Questionregular expression [modified] Pin
Sonia Gupta27-Dec-07 17:46
Sonia Gupta27-Dec-07 17:46 
GeneralRe: regular expression Pin
aswini27-Dec-07 19:19
aswini27-Dec-07 19:19 
GeneralRe: regular expression Pin
Sonia Gupta27-Dec-07 19:26
Sonia Gupta27-Dec-07 19:26 
GeneralRe: regular expression Pin
sulabh202027-Dec-07 19:39
sulabh202027-Dec-07 19:39 
GeneralRe: regular expression Pin
N a v a n e e t h27-Dec-07 19:48
N a v a n e e t h27-Dec-07 19:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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