|
Hi,
Need a simple create table script for SQL server 2007.
Here's the structure:
Column1: primary key, integer, auto increment
Column2: Name, char, length 100, not null
Column3: address, char length 200, not null
Please help
ASP - AJAX is SEXY. PERIOD.
|
|
|
|
|
Bulky Fellow wrote: SQL server 2007.
No such product. Did you mean SQL Server 2005?
CREATE TABLE dbo.SomeTableName
(
SomeColumnName INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
Name CHAR(100) NOT NULL,
address CHAR(200) NOT NULL
);
May I recomment that you use VARCHAR instead of the CHAR type that you requested.
|
|
|
|
|
|
Thanks a lot for your help!
And by the way, I meant SQL server 2000. Made a mistake there.
ASP - AJAX is SEXY. PERIOD.
|
|
|
|
|
How to lock folders.
Help.
Vasildb
|
|
|
|
|
What are you trying to do? You may want to be more articulate.
|
|
|
|
|
I think he might mean that he wants to lock a folder in the same way that Windows prevents you from looking in System folders.
---
Sup!
|
|
|
|
|
Yes. Do not view or can not open.
Vasildb
|
|
|
|
|
Hi,
Iam Mahender. Can anyone Plz tell me How remove session in my web-application. My web application consists of Report viewer control. Can u tell me How to write a class that implements IReportserverconnection. I wrote Class that implements IReportserverconnection Interface , implemented all Properties and Method.( I took Guidance from .(taking Guidance 4m (http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportserverconnection2(VS.80).aspx).For the First time When Page loads, Upon Clicking a Button, a Report gets Loaded Successfully, When I select second page of Report or try to export Report to XML(Or Other Formats) I try to get exception as
“The source of the report definition has not been specified".”.
I request anyone to Plz tell me solution for this problem……….
Waiting for ur Replies……
With Regards,
S.N.P.C Mahender,
mhi
|
|
|
|
|
Hi all,
can anyone of you tell me how to set number of columns in a repeater control. I've to set 11 link buttons in a repeater control in horizontal position.There is no property for set the columns in repeater control.If i increase the length, it displays the data in vertical. So pls tell me ASAP.
Thanks & Regards
Babu
|
|
|
|
|
hi
U can set property i.e repeater1.RepeatColumns =11 and Repeater1.ReapeatDirection=repeatFDirection.horizental
just see, then give
|
|
|
|
|
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.
|
|
|
|
|
Check DataList control
[^]
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it!
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Actually its come from user input
thank you.
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
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);
|
|
|
|
|
thank you Guffa
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Hello!
Is there something like OpenFileDialog but which only returns a path and not a file?
/Regards
|
|
|
|
|
hi
use the FolderBrowserDialog in the forms namespace
|
|
|
|
|
|
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;
}
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|