Click here to Skip to main content
15,915,828 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: iis problems Pin
Parwej Ahamad18-Sep-07 20:14
professionalParwej Ahamad18-Sep-07 20:14 
AnswerRe: iis problems Pin
rahul.net1119-Sep-07 5:02
rahul.net1119-Sep-07 5:02 
Questionhow to access the TextBox control of User Control Pin
Elena200618-Sep-07 18:45
Elena200618-Sep-07 18:45 
AnswerRe: how to access the TextBox control of User Control Pin
Christian Graus18-Sep-07 19:26
protectorChristian Graus18-Sep-07 19:26 
AnswerRe: how to access the TextBox control of User Control Pin
chiragfriend20056218-Sep-07 19:48
chiragfriend20056218-Sep-07 19:48 
QuestionHow to access method declared in Master page Pin
Elena200618-Sep-07 18:42
Elena200618-Sep-07 18:42 
AnswerRe: How to access method declared in Master page Pin
Christian Graus18-Sep-07 19:25
protectorChristian Graus18-Sep-07 19:25 
Questionretrieve ?id, error on parameter on mysql connector Pin
Louie Miranda18-Sep-07 18:10
Louie Miranda18-Sep-07 18:10 
How can i retrieve the ?id, error always is parameter is missing?

code below
###########################################

MySqlConnection conn = new MySqlConnection("server=192.168.10.1;database=test;user id=test;password=test;");
conn.Open();
MySqlCommand comm = new MySqlCommand("LOCK TABLES profile WRITE", conn);
comm.ExecuteNonQuery();

comm = new MySqlCommand(String.Format("SELECT * from profile where id = ?id"), conn);
MySqlDataReader reader = comm.ExecuteReader();

int retrievedId = reader.GetInt32("id");
//comm.Parameters.Add("?id", retrievedId);

comm.Parameters.Add("id", MySqlDbType.Int32).Value = retrievedId.id;

DataTable myDataTable = new DataTable();
myDataTable.Load(reader);
reader.Close();

DetailsView1.DataSource = myDataTable;
DetailsView1.DataBind();
DetailsView1.Dispose();

comm = new MySqlCommand("UNLOCK TABLES", conn);
comm.ExecuteNonQuery();
conn.Close();
DetailsView1.Dispose();
###########################################

Thanks
AnswerRe: retrieve ?id, error on parameter on mysql connector Pin
Christian Graus18-Sep-07 18:25
protectorChristian Graus18-Sep-07 18:25 
AnswerRe: retrieve ?id, error on parameter on mysql connector Pin
VenkataRamana.Gali18-Sep-07 18:27
VenkataRamana.Gali18-Sep-07 18:27 
GeneralRe: retrieve ?id, error on parameter on mysql connector Pin
Louie Miranda18-Sep-07 18:40
Louie Miranda18-Sep-07 18:40 
GeneralRe: retrieve ?id, error on parameter on mysql connector Pin
VenkataRamana.Gali18-Sep-07 19:06
VenkataRamana.Gali18-Sep-07 19:06 
GeneralRe: retrieve ?id, error on parameter on mysql connector Pin
Louie Miranda18-Sep-07 19:24
Louie Miranda18-Sep-07 19:24 
GeneralRe: retrieve ?id, error on parameter on mysql connector Pin
Christian Graus18-Sep-07 19:24
protectorChristian Graus18-Sep-07 19:24 
QuestionHelp me! About Select Folder Dialog! Pin
khkly18-Sep-07 16:42
khkly18-Sep-07 16:42 
AnswerRe: Help me! About Select Folder Dialog! Pin
Christian Graus18-Sep-07 17:43
protectorChristian Graus18-Sep-07 17:43 
QuestionVery slow GridView Pin
RanjithLogics18-Sep-07 16:14
RanjithLogics18-Sep-07 16:14 
AnswerRe: Very slow GridView Pin
VenkataRamana.Gali18-Sep-07 18:23
VenkataRamana.Gali18-Sep-07 18:23 
GeneralRe: Very slow GridView Pin
RanjithLogics18-Sep-07 18:27
RanjithLogics18-Sep-07 18:27 
GeneralRe: Very slow GridView Pin
VenkataRamana.Gali18-Sep-07 18:30
VenkataRamana.Gali18-Sep-07 18:30 
GeneralRe: Very slow GridView Pin
RanjithLogics18-Sep-07 18:42
RanjithLogics18-Sep-07 18:42 
QuestionGenerate CSV File from database Pin
C#Coudou18-Sep-07 15:10
C#Coudou18-Sep-07 15:10 
AnswerRe: Generate CSV File from database Pin
VenkataRamana.Gali18-Sep-07 18:18
VenkataRamana.Gali18-Sep-07 18:18 
QuestionUse javascript in User control Pin
kjosh18-Sep-07 15:07
kjosh18-Sep-07 15:07 
AnswerRe: Use javascript in User control Pin
Christian Graus18-Sep-07 15:40
protectorChristian Graus18-Sep-07 15:40 

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.