Click here to Skip to main content
15,887,027 members
Home / Discussions / C#
   

C#

 
GeneralAdapt forms to screen resolution Pin
haezeban8-Feb-04 7:55
haezeban8-Feb-04 7:55 
GeneralRe: Adapt forms to screen resolution Pin
Mazdak8-Feb-04 8:24
Mazdak8-Feb-04 8:24 
GeneralRe: Adapt forms to screen resolution Pin
Heath Stewart8-Feb-04 18:07
protectorHeath Stewart8-Feb-04 18:07 
Questionminimize to tray? Pin
visiontec8-Feb-04 7:43
visiontec8-Feb-04 7:43 
AnswerRe: minimize to tray? Pin
OmegaSupreme8-Feb-04 10:18
OmegaSupreme8-Feb-04 10:18 
GeneralRe: minimize to tray? Pin
visiontec9-Feb-04 11:34
visiontec9-Feb-04 11:34 
GeneralRe: minimize to tray? Pin
OmegaSupreme9-Feb-04 15:25
OmegaSupreme9-Feb-04 15:25 
GeneralAdding parameters to a table Pin
Andrlage8-Feb-04 5:30
Andrlage8-Feb-04 5:30 
Hi,
I'm expecting to get an extra column named 'state' displayed in the datagrid but it doesnt add one.
Can you please help me find out the problem with the source code.

SqlConnection myConnection = new SqlConnection(
"server=(local);database=demo;Integrated Security=SSPI");

SqlDataAdapter myCommand = new SqlDataAdapter ("select * from demo", myConnection);

/* myCommand.SelectCommand.Parameters.Add(new SqlParameter("@State", SqlDbType.NVarChar, 2));
myCommand.SelectCommand.Parameters["@State"].Value = MySelect.Value
*/
try
{
myCommand.SelectCommand.Parameters.Add(new SqlParameter("@State",SqlDbType.NVarChar,2));
myCommand.SelectCommand.Parameters["@State"].Value = "aa";
}
catch(Exception ex)
{
Response.Write(ex.Message);
}

DataSet ds = new DataSet();
myCommand.Fill(ds, "mytable");

DataGrid1.BorderColor=Color.Black;
DataGrid1.BorderWidth=1;
DataGrid1.GridLines=GridLines.Both;
DataGrid1.CellPadding=3;
DataGrid1.CellSpacing=0;
DataGrid1.HeaderStyle.BackColor=Color.FromArgb(0xaaaadd);

DataGrid1.DataSource=ds.Tables["mytable"].DefaultView;
DataGrid1.DataBind();

Yours sincerely
Andla
GeneralRe: Adding parameters to a table Pin
Nick Parker8-Feb-04 6:02
protectorNick Parker8-Feb-04 6:02 
QuestionMost efficient way of doing this? Pin
Alex Korchemniy7-Feb-04 22:31
Alex Korchemniy7-Feb-04 22:31 
GeneralZooming approach Pin
Meysam Mahfouzi7-Feb-04 18:08
Meysam Mahfouzi7-Feb-04 18:08 
GeneralRe: Zooming approach Pin
Heath Stewart7-Feb-04 19:00
protectorHeath Stewart7-Feb-04 19:00 
GeneralCombo Box problem... Pin
je_gonzalez7-Feb-04 17:27
je_gonzalez7-Feb-04 17:27 
GeneralDatabase Pin
ASGill7-Feb-04 17:16
ASGill7-Feb-04 17:16 
GeneralRe: Database Pin
Heath Stewart7-Feb-04 18:50
protectorHeath Stewart7-Feb-04 18:50 
GeneralMore Thread Troubles; not sure if it's deadlock Pin
Peter Mills7-Feb-04 14:41
Peter Mills7-Feb-04 14:41 
GeneralRe: More Thread Troubles; not sure if it's deadlock Pin
Heath Stewart7-Feb-04 18:58
protectorHeath Stewart7-Feb-04 18:58 
GeneralWell it's got me stumped Pin
Rob Manderson7-Feb-04 14:08
protectorRob Manderson7-Feb-04 14:08 
GeneralRe: Well it's got me stumped Pin
Rob Manderson7-Feb-04 16:25
protectorRob Manderson7-Feb-04 16:25 
GeneralRe: Well it's got me stumped Pin
Heath Stewart7-Feb-04 19:08
protectorHeath Stewart7-Feb-04 19:08 
GeneralRe: Well it's got me stumped Pin
Rob Manderson7-Feb-04 22:25
protectorRob Manderson7-Feb-04 22:25 
GeneralRe: Well it's got me stumped Pin
Heath Stewart8-Feb-04 5:40
protectorHeath Stewart8-Feb-04 5:40 
QuestionHow to make panel scroll when scrollbar is moved? Pin
rul3037-Feb-04 13:45
rul3037-Feb-04 13:45 
AnswerRe: How to make panel scroll when scrollbar is moved? Pin
Heath Stewart7-Feb-04 19:12
protectorHeath Stewart7-Feb-04 19:12 
GeneralRe: How to make panel scroll when scrollbar is moved? Pin
rul3038-Feb-04 7:02
rul3038-Feb-04 7:02 

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.