Click here to Skip to main content
15,912,205 members
Home / Discussions / C#
   

C#

 
GeneralRe: sql script execuation Pin
Tamimi - Code24-Jun-06 3:47
Tamimi - Code24-Jun-06 3:47 
AnswerRe: sql script execuation Pin
Michael P Butler24-Jun-06 7:05
Michael P Butler24-Jun-06 7:05 
AnswerRe: sql script execuation Pin
Colin Angus Mackay24-Jun-06 10:46
Colin Angus Mackay24-Jun-06 10:46 
GeneralRe: sql script execuation Pin
_tasleem27-Jun-06 4:47
_tasleem27-Jun-06 4:47 
Questionc # code for pushing objects from desktop to bluetooth devices Pin
piyushnarain24-Jun-06 2:31
piyushnarain24-Jun-06 2:31 
QuestionGDI+ question aagain Pin
User 309585924-Jun-06 2:19
User 309585924-Jun-06 2:19 
AnswerRe: GDI+ question aagain Pin
Ed.Poore24-Jun-06 12:48
Ed.Poore24-Jun-06 12:48 
QuestionObject must implement IConvertible Pin
ujupanmester24-Jun-06 1:46
ujupanmester24-Jun-06 1:46 
I'm trying to insert a record into a sql server 2000 database using a store
procedure (vs.net is my develop tool) on the button click event but I keep
getting the following error after clicking the button:
Object must implement IConvertible.

When i try to read TemplateColumns from datagrid and to insert in sql server table, i think is the problem.
I don't have any trace.


Code:

public void inscriereemail()
{
string conn = ConfigurationSettings.AppSettings["conn"];
SqlConnection objConnection = new SqlConnection(conn);
SqlCommand mycmd = new SqlCommand("add_email", objConnection);

mycmd.CommandType = CommandType.StoredProcedure;

lblint.Text = Request.QueryString["id"];

SqlParameter expeditorp=new SqlParameter ("@expeditor", SqlDbType.VarChar, 4);
expeditorp.Direction=ParameterDirection.Input;
expeditorp.Value= lbluser.Text;
mycmd.Parameters.Add(expeditorp);

SqlParameter destinatar1p=new SqlParameter ("@destinatar", SqlDbType.VarChar, 5);
destinatar1p.Direction=ParameterDirection.Input;
destinatar1p.Value = dgdest.Items[0].FindControl("lbldest"); <- Problemns
mycmd.Parameters.Add(destinatar1p);

SqlParameter destinatarp=new SqlParameter ("@destinatar_camion", SqlDbType.VarChar, 4);
destinatarp.Direction=ParameterDirection.Input;
destinatarp.Value= lblint.Text;
mycmd.Parameters.Add(destinatarp);

SqlParameter titlup=new SqlParameter ("@titlu", SqlDbType.VarChar, 25);
titlup.Direction=ParameterDirection.Input;
titlup.Value=txttitlu.Text;
mycmd.Parameters.Add(titlup);

SqlParameter mesajp=new SqlParameter ("@mesaj", SqlDbType.VarChar, 800);
mesajp.Direction=ParameterDirection.Input;
mesajp.Value=txtmesaj.Text;
mycmd.Parameters.Add(mesajp);

SqlParameter cititp=new SqlParameter ("@citit", SqlDbType.VarChar, 1);
cititp.Direction=ParameterDirection.Input;
cititp.Value = "1";
mycmd.Parameters.Add(cititp);

SqlParameter trashp=new SqlParameter ("@trash", SqlDbType.VarChar, 1);
trashp.Direction=ParameterDirection.Input;
trashp.Value = "1";
mycmd.Parameters.Add(trashp);


SqlParameter data_adaugarep=new SqlParameter ("@data_adaugare", SqlDbType.VarChar, 35);
data_adaugarep.Direction=ParameterDirection.Input;
data_adaugarep.Value = lblTime.Text;
mycmd.Parameters.Add(data_adaugarep);



try
{
objConnection.Open();
mycmd.ExecuteNonQuery();
}

finally
{
if (objConnection.State == ConnectionState.Open)
{
objConnection.Close();
}
}
}
AnswerRe: Object must implement IConvertible Pin
leppie24-Jun-06 7:22
leppie24-Jun-06 7:22 
GeneralRe: Object must implement IConvertible Pin
ujupanmester24-Jun-06 12:58
ujupanmester24-Jun-06 12:58 
QuestionHelp me [modified] Pin
AnhTin24-Jun-06 0:33
AnhTin24-Jun-06 0:33 
AnswerRe: Help me Pin
Jun Du24-Jun-06 2:28
Jun Du24-Jun-06 2:28 
QuestionTransaction control [modified - more details on the problem] Pin
jith - iii24-Jun-06 0:04
jith - iii24-Jun-06 0:04 
Questiondrag-drop into windows application in C# Pin
nagramana23-Jun-06 23:34
nagramana23-Jun-06 23:34 
AnswerRe: drag-drop into windows application in C# Pin
Guffa23-Jun-06 23:52
Guffa23-Jun-06 23:52 
GeneralRe: drag-drop into windows application in C# Pin
nagramana24-Jun-06 0:10
nagramana24-Jun-06 0:10 
GeneralRe: drag-drop into windows application in C# Pin
Guffa24-Jun-06 0:29
Guffa24-Jun-06 0:29 
GeneralRe: drag-drop into windows application in C# Pin
Paul Conrad24-Jun-06 19:14
professionalPaul Conrad24-Jun-06 19:14 
AnswerRe: drag-drop into windows application in C# Pin
Michael P Butler24-Jun-06 1:08
Michael P Butler24-Jun-06 1:08 
QuestionFast dynamic loading of assemblies using reflection Pin
roxtar23-Jun-06 22:49
roxtar23-Jun-06 22:49 
QuestionData Table - Sort [urgent] Pin
SysJey23-Jun-06 22:41
SysJey23-Jun-06 22:41 
AnswerRe: Data Table - Sort [urgent] [modified] Pin
Michael P Butler24-Jun-06 0:56
Michael P Butler24-Jun-06 0:56 
GeneralData Table - Sort Pin
SysJey25-Jun-06 22:44
SysJey25-Jun-06 22:44 
QuestionData Table - Sort [urgent] Pin
SysJey23-Jun-06 22:41
SysJey23-Jun-06 22:41 
QuestionI can't Debug on Pocket PC2002 Emulator [modified] Pin
tr_hoaiphong23-Jun-06 22:32
tr_hoaiphong23-Jun-06 22:32 

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.