Comments by fady_hasnaa (Top 21 by date)

when puting rational_obj.OfficeWordApproveDate=DateTime.MinValue
in inserting to db it will be like this
INSERT INTO RationaleSystemicTbl
(SchID ,InsuranceOrderNO, InsuranceEDate, InsuranceNoOfSubscribeSToutorial, InsuranceNoOfSubscribeNSToutorial,InsuranceNoOfSubscribeSAdimistrator, InsuranceNoOfSubscribeNSAdimistrator, InsuranceNoOfSubscribeSUsers, InsuranceNoOfSubscribeNSUsers, JoinFilledSchoolDate, AmanahApprove, AmanaApproveDate, FileNoInOfficeWork, OfficeWorkApprove, AlzakahEDate, OfficeWorkApproveDate, TaesheeratTotal, TaesheeratUse, TaesheeratUnUse,Amanah_approve_num,Office_work_approve_num,non_sa_on_kfalah)
VALUES(N'1988',3249423,CONVERT(VARCHAR(10),'10/8/2014', 111) , 16, 16, 19,7, 18, 18, CONVERT(VARCHAR(10),'9/25/2014', 111) , 0, CONVERT(VARCHAR(10),'12:00:00 AM', 111) , 03293232,null , CONVERT(VARCHAR(10),'10/29/2014', 111) , CONVERT(VARCHAR(10),'12:00:00 ', 111) ,null , 17, 16, 14,null,17)
---------------
CONVERT(VARCHAR(10),'12:00:00 ', 111) and the column is datetime will not accept string how can i fix it ?
as i can not put it to nullable as sometimes it has value

i do it but still the same problem

no sir,
this link for gridview in asp iam talking about datagrid in c#

i have other question plz when trying to change date and start service of analsis sql
sql is running and working did you have any idea about this as iam new

ok , what i get from your answer is upgrade sql server to standard edition ,
first i don not purchase sql server so the source of evaluation sql i just go to setup .exe file from maintaince do upgrade as i do not have a serial key iam doing the upgrade to free edition is this right? as it 's stop suddlent and analysis service upgrade faild
what can i do to move to standard as i don not have a purchased serial key
thanks in advanced

no way to make sql server 2008 r2 work without installing standared ?
i mean no way to edit in registry which can make it work ?

no it's firing see in gridvier onrowedite
did you have any idea about the other peoblem ?

thanks

thanks my dear but i want to ask about other thing
in code in asp in linkboutton when i write onclick="functio_name"
and in code behind the header of the function name like this :
protected void function_name()
error said :No overload for 'insert_row' matches delegate 'System.EventHandler'
after search i found that to fix this you have to change the header of function to
protedted void function_name(object sender , Eventargs e )
it's working well , could you tell me why shall i add this ?

well , i got why the error happen because t.cust_no is null ,
but you did not get my point i want to make insert when clicking the link i mean i want an empty row then i can fill it with data this is the way i found on google to make insert link,
but it odes not work did you have if iam going in the right way or not ?

thanks my dear

so what if i write
if (charcode>57)
?

ok what if
i want to make datagridview containn 3 column ser_code- ser_type-ser_name
the ser-type is dropdawnlist and the other column is text the value of set-name and ser-type in datagrid depend on the value selected in ser-type (dropdawnlist ) inside datagrid
how can i made it in c#?
i now how to add dropdawnlistcolumn to grid
could any one tell me the complete way for something like this ?

also this is a strait line , i want the line is drwaning as the mouse move not as strait

thanks ,
but i have other question
this is my code

private void Form1_MouseMove(object sender, MouseEventArgs e)
{
//drwa line
Point oldpoint = new Point();

Graphics ex = CreateGraphics();


if (e.Button == MouseButtons.Left)
{
Pen myPen = new Pen(Color.Red);
ex.DrawLine(myPen, oldpoint.X, oldpoint.Y, e.X, e.Y);
oldpoint = e.Location;


}
//erase line
else if (e.Button == MouseButtons.Right)
{
Point secondold=new Point ();
Pen o = new Pen(this.BackColor);
Graphics er = CreateGraphics();
er.DrawLine(o, secondold.X, secondold.Y, e.X, e.Y);
secondold = e.Location;


}

}

private void Form1_Load(object sender, EventArgs e)
{
this.ResizeRedraw = true;
}

private void Form1_Resize(object sender, EventArgs e)
{
Invalidate();
}


when trying to resize the form every thind erased
i wrote this.resizeredraw= true in resize event but nothing happen
did you have any idea about this ?

hi ,
thanks all solution 2 is correct answer ,
but i habve athoer problem
when trying to setup sql 64 message appear said
"SQL Server setup media does not support the language of the OS or does not have ENU localized files. Use the matching language-specific SQL Server media or change the OS locale through control panel.
"
i tried change languge of my pc to english united state but still having the errot
could any one help me ?