C# Discussion Boards - CodeProject

Re: how to set number of columns in repeater control?

17-Jan-07 1:41

hi
U can set property i.e repeater1.RepeatColumns =11 and Repeater1.ReapeatDirection=repeatFDirection.horizental

just see, then give

babutkchn17-Jan-07 1:48

babutkchn

17-Jan-07 1:48

but there is no property called repeatColumns and repeatdirection. Is there anyother way?? it might be in framework 1.1. i'm using 2.0 version.

Re: how to set number of columns in repeater control?

Elina Blank17-Jan-07 2:38

Elina Blank

17-Jan-07 2:38

Check DataList control
[^]

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

date problem

Tamimi - Code17-Jan-07 1:16

Tamimi - Code

17-Jan-07 1:16

hi all
On my computer this string "22-1-2007" considered as a valid date , but on the client computer its not, its throw an exception when I convert it to datetime , because the system date format is MM-dd-yyyy.
So what I have to avoid this problem ?

When you get mad...THINK twice that the only advice
Tamimi - Code

Colin Angus Mackay17-Jan-07 1:50

17-Jan-07 1:50

Tamimi - Code wrote:
On my computer this string "22-1-2007" considered as a valid date , but on the client computer its not, its throw an exception when I convert it to datetime , because the system date format is MM-dd-yyyy.
So what I have to avoid this problem ?

It depends on where the date string came from. If it was generated internally and is never displayed to the user before becoming a DateTime object then my recommendation is to always use ISO date format (year-month-day).

If the string did come from user input then you'll have to look at localising your application.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Tamimi - Code17-Jan-07 2:20

Tamimi - Code

17-Jan-07 2:20

Actually its come from user input
thank you.

When you get mad...THINK twice that the only advice
Tamimi - Code

Guffa17-Jan-07 1:55

Guffa

17-Jan-07 1:55

Here are some options:

:: Use a standardised date format, like ISO 8601: yyyy-mm-dd.

:: Use ParseExact so that you can specify the exact format.

:: Specify a CultureInfo or FormatInfo when you parse the date. You should really do this every time you convert culture dependent information.

---
Year happy = new Year(2007);

how to drag and drop a label in a panel?

Tamimi - Code17-Jan-07 2:21

Tamimi - Code

17-Jan-07 2:21

thank you Guffa

When you get mad...THINK twice that the only advice
Tamimi - Code

OpenPathDialog?

livez17-Jan-07 1:14

livez

17-Jan-07 1:14

Hello!

Is there something like OpenFileDialog but which only returns a path and not a file?

/Regards

Re: OpenPathDialog?

JoeSharp17-Jan-07 1:22

JoeSharp

17-Jan-07 1:22

hi
use the FolderBrowserDialog in the forms namespace

Re: OpenPathDialog?

livez17-Jan-07 1:30

livez

17-Jan-07 1:30

thanks!

greyzz17-Jan-07 1:06

greyzz

17-Jan-07 1:06

how can i move a label that is in a panel? i dont know what to do in the draganddrop event of the panel. how do i relocate the label? do i need the pointtoclient?

here's the code:

static void newPanel_DragDrop(object sender, DragEventArgs e)

{

}

static void newPanel_DragEnter(object sender, DragEventArgs e)

{

e.Effect = DragDropEffects.Move;

}

Re: how to drag and drop a label in a panel?

Vinay Dornala17-Jan-07 1:36

Writing message in eventlog

17-Jan-07 1:36

hi
Just see this code for tabcontrol,selecting the required tabpage from tabcontrol1 and dragging form tabcontrol1 and drop it tabcontrol2.

I hope this will be helpful for u.

private void tabControl1_MouseMove( object sender, MouseEventArgs e )
{
if ( e.Button == MouseButtons.Left )
tabControl1.DoDragDrop( tabControl1.SelectedTab, DragDropEffects.All );
}

private void tabControl2_DragEnter( object sender, DragEventArgs e )
{
e.Effect = e.Data.GetDataPresent( typeof( TabPage ) )
? DragDropEffects.Move
: DragDropEffects.None;
}

private void tabControl2_DragDrop( object sender, DragEventArgs e )
{
TabPage DropTab = (TabPage)( e.Data.GetData( typeof( TabPage ) ) );
tabControl2.TabPages.Add( DropTab );
}

WiNNING IS NOT OUR DREAM,IT'S A HABIT

Have a nice evening

ParagGupta16-Jan-07 23:52

ParagGupta

16-Jan-07 23:52

Hi All,

I am developing a windows application. In that application I have to write an entry in eventlog at the time when the application is closed. The problem is that application dont have any UI(User Interface) so it can closed only through taskmanager.
So is there any method or exception to catch it and then send an entry catching it in eventlog.

Regards,
Parag

how to store data from c# into sql server data base

rao raja16-Jan-07 23:29

rao raja

16-Jan-07 23:29

i need to know that if many values are entered into a c# form, then i want to add all those in
the dataBase.so what will be the code lines.plz reply someone

Re: how to store data from c# into sql server data base

Colin Angus Mackay17-Jan-07 0:01

Re: how to store data from c# into sql server data base

17-Jan-07 0:01

Create a SqlCommand to INSERT the data in the database.

SqlCommand cmd = new SqlCommand();
cmd.Connection = aConnection;
cmd.CommandText = "INSERT TableName(Column1, Column2, Column3) "+
                  "VALUES (@Value1, @Value2, Value3";
cmd.Parameters.Add("@Value1", theFirstValue);
cmd.Parameters.Add("@Value2", theSecondValue);
cmd.Parameters.Add("@Value3", theThirdValue);
cmd.ExecuteNonQuery();

You will have to replace theFirstValue, theSecondValue and theThirdValue with appropriate values. Also, you will have to restructure the INSERT statement to match your database. I've also assumed that you have a connection (aConnection) to the database.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Vinay Dornala17-Jan-07 0:08

Re: how to store data from c# into sql server data base

17-Jan-07 0:08

hi
First write StoredProcedure like for Insert

Create StoredProc nameofStoredProc
(

@firstname varchar(20),
@lastname varchar(20))
as
insert into tablename
(
firstname,
lastname
)
values
(
@fisrtname,
@lastname
)

then start writing ADO.net code

SqlConnection con=new SqlConnection("userid=""; password="";DataSource="");
con.Open();
SqlCommand cmd=new SqlCommand("nameofStroredProc",con);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameter.Add(new SqlParameter("@firstname",SqlDbType.varchar);
cmd.Parameter.Add(new SqlParameter("@lastname",SqlDbType.varchar);
cmd.parameter[0].value= txtFirstName.text;//textbox value
cmd.Parameter[1].value=txtlastName.Text;//textbox value
cmd.ExecuteNonQuery();
con.Close();

WINNING IS NOT OUR DREAM, IT'S A HABIT

HAVE A NICE DAY

Colin Angus Mackay17-Jan-07 0:29

Re: how to store data from c# into sql server data base

17-Jan-07 0:29

dornala wrote:
SqlConnection con=new SqlConnection("userid=""; password="";DataSource="");

A SqlConnection needs both a server and database name. Also, It is better to use a trusted connection than supply a user name and password in plain text.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Vinay Dornala17-Jan-07 1:29

Re: how to store data from c# into sql server data base

17-Jan-07 1:29

hi

Just Iam specifing a simple connection for an example.

It is good practice to give entire connection object.

Colin Angus Mackay17-Jan-07 1:47