Click here to Skip to main content
15,922,894 members
Home / Discussions / Database
   

Database

 
GeneralRe: showing parts of a table in datagrid Pin
Anonymous28-Aug-05 3:39
Anonymous28-Aug-05 3:39 
QuestionAlias for table names Pin
smita_roy26-Aug-05 1:45
smita_roy26-Aug-05 1:45 
AnswerRe: Alias for table names Pin
Not Active26-Aug-05 3:47
mentorNot Active26-Aug-05 3:47 
AnswerRe: Alias for table names Pin
softty28-Aug-05 8:27
softty28-Aug-05 8:27 
Questiondynamic datasource on reporting services Pin
Ali Sapanci25-Aug-05 23:18
Ali Sapanci25-Aug-05 23:18 
AnswerRe: dynamic datasource on reporting services Pin
Ali Sapanci28-Aug-05 22:28
Ali Sapanci28-Aug-05 22:28 
Questionquerying a Acces DataBase Pin
Binary011025-Aug-05 21:26
Binary011025-Aug-05 21:26 
AnswerRe: querying a Acces DataBase Pin
beatles169227-Aug-05 2:22
beatles169227-Aug-05 2:22 
if you are showing an ID field in your list you can use the id ( whenever is selected by the user) and select the record and then show its field in your text boxes.
for example:
using System.Data;
using System.Data.OleDb;

public void listbox_click(object sender,EventArgs e)
{
string selecet_string="SELECT * FROM MyTable WHERE id="+listbox.selectedItem.ToString();
DataSet ds=new DataSet();
OleDbDataAdapter adapter=new OleDbDataAdapter(select_string,cnn) //you should pass your own connection object.
adapter.Fill(ds);
//Then you can fill the text boxes
textBox1.Text=ds.Tables[0].Rows[0][0].ToString();
//etc.
}
QuestionMore info on: Error Could Not Lock File Pin
Javolin25-Aug-05 12:28
Javolin25-Aug-05 12:28 
GeneralMDAC Sdk 2.8 Help Pin
dvptUml24-Aug-05 13:46
dvptUml24-Aug-05 13:46 
GeneralRecord locking ADO -net Pin
HahnTech24-Aug-05 9:47
HahnTech24-Aug-05 9:47 
GeneralRe: Record locking ADO -net Pin
miah alom25-Aug-05 8:36
miah alom25-Aug-05 8:36 
GeneralRe: Record locking ADO -net Pin
HahnTech25-Aug-05 8:51
HahnTech25-Aug-05 8:51 
GeneralRe: Record locking ADO -net Pin
Rob Graham26-Aug-05 11:48
Rob Graham26-Aug-05 11:48 
GeneralRe: Record locking ADO -net Pin
Alomgir Miah28-Aug-05 7:39
Alomgir Miah28-Aug-05 7:39 
QuestionOpen Source Data Modeling Software? Pin
Turtle Hand24-Aug-05 7:34
Turtle Hand24-Aug-05 7:34 
QuestionInsert Null Value to Foxpro table? Pin
Member 185596324-Aug-05 5:58
Member 185596324-Aug-05 5:58 
AnswerRe: Insert Null Value to Foxpro table? Pin
Michael Potter25-Aug-05 9:55
Michael Potter25-Aug-05 9:55 
GeneralRe: Insert Null Value to Foxpro table? Pin
Member 185596325-Aug-05 22:30
Member 185596325-Aug-05 22:30 
GeneralRe: Insert Null Value to Foxpro table? Pin
Michael Potter26-Aug-05 3:43
Michael Potter26-Aug-05 3:43 
GeneralRe: Insert Null Value to Foxpro table? Pin
Member 185596326-Aug-05 3:54
Member 185596326-Aug-05 3:54 
Generalte data in just one columnBulk Insert from text File Pin
Daredeviljpr24-Aug-05 5:04
Daredeviljpr24-Aug-05 5:04 
GeneralRe: te data in just one columnBulk Insert from text File Pin
Frank Kerrigan24-Aug-05 6:03
Frank Kerrigan24-Aug-05 6:03 
GeneralRe: te data in just one columnBulk Insert from text File Pin
Daredeviljpr25-Aug-05 3:48
Daredeviljpr25-Aug-05 3:48 
GeneralStored Procedures or Direct SQL Statements Pin
emadns24-Aug-05 0:23
emadns24-Aug-05 0:23 

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.