|
There are lots of beginner books. It really depends on your style of learning. Go to the book store and browse through a few books. Pick the one that appeals to you most.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
Thanks for help.
Rahul Kulkarni
|
|
|
|
|
Hello i am facing a slight problem with Store a record in the database.
I have a column of Type Decimal (It can have null values in the DB).
i take the input in a textbox and saves it to the database.
dataRow["SPEED"] = (this.tbSpeed.Text == "" ? DBNull.Value.ToString() : this.tbSpeed.Text);
If I leave it blank it gives me following error
An unhandled exception of type 'System.ArgumentException' occurred in System.Data.dll
Additional information: Input string was not in a correct format.Couldn't store <> in SPEED Column. Expected type is Decimal
What could be the solution to this problem
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o°
»·'"`»* *☆ t4ure4n ☆* *«·'"`«
°o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
|
|
|
|
|
t4urean wrote: DBNull.Value.ToString()
Why are you suppling a ToString() on DBNull.Value ? Don't do that just pass DBNull.Value
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
If I don't use DbNull.value.tostring() then i get the following error
Type of conditional expression cannot be determined because there is no implicit conversion between 'System.DBNull' and 'string'
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o°
»·'"`»* *☆ t4ure4n ☆* *«·'"`«
°o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
|
|
|
|
|
I suspect that is because of the trinary operator that you are using. These are generally considered to be bad practice.
Try this:
if (this.tbSpeed.Text == "")
dataRow["SPEED"] = DBNull.Value;
else
dataRow["SPEED"] = this.tbSpeed.Text;
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
And I'd guess that that the contents of the text box will need to be converted to a decimal also.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
Try this:
dataRow["Speed"] = this.tbSpeed.Text ?? (object) DBNull.Value;
|
|
|
|
|
IF you would use a simple "IF", it would be very simple.
|
|
|
|
|
I have used this even then i am getting the same error
if (this.tbSpeed.Text == "")
dataRow["SPEED"] = DBNull.Value;//"NULL";
else
dataRow["SPEED"] = this.tbSpeed.Text;
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o°
»·'"`»* *☆ t4ure4n ☆* *«·'"`«
°o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
|
|
|
|
|
Your manner of storing values in the database seems pretty unusual. I would create a command with an "INSERT" statement as the command text and call it's ExecuteNonQuery() method. For the decimal column I would use an SQL Parameter of decimal type to avoid format errors.
|
|
|
|
|
I have found the solution... Just applied the validation when creating the query string and it works fine to specify NUll for an empty string.
I am doing in the same way you are saying
but i have a seperate class that deals with it when provided with a data row.
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o°
»·'"`»* *☆ t4ure4n ☆* *«·'"`«
°o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
|
|
|
|
|
how can i divide a windows forms in two half horizontally. The upper half contains one listview control and the lower half contains another list view control. and how can i manage the size when the form is expanded making sure that two list view doest overlap each other(i.e when form is expanded);
|
|
|
|
|
You can use a split container. It's in the toolbox. It creates two panels that you can put your controls into with a resizable divider. It ensures that the controls don't overlap. You can set it to be horizonal or vertical.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
is it availabe in dotnet 2003 or frame work 1.1
|
|
|
|
|
justintimberlake wrote: is it availabe in dotnet 2003 or frame work 1.1
According to MSDN[^] the answer is no.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
No, it isn't, but the Splitter control is.
You can simply add two Panels and a Splitter to your form to achieve a similar effect with .NET 1.1.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
Hi,
I installed the SQL Server 2005 with all components.
I need to do practice in that IDE As i study.but it not new->project template as i saw...it is same as visual studio 2005.
i neet BI IDE templates as its(default)
SQL Server Business Intelligence Development Studio.
Thanks in advance!
|
|
|
|
|
This does not appear to be a question about C#. Try posting in a more appropriate forum.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
hi guys
i am doing the following but it does not work, there is no error or exception
but the file acees rights are not changes, means i cant allow or deny file access rights with this code in my application, i m pasting the code plz help me out there?
FileSecurity fs = System.IO.File.GetAccessControl(@"\\Jpak02\Comm for ITS\TAhmad",
AccessControlSections.Access);
FileSystemAccessRule ar = new FileSystemAccessRule
("mkhkhan", FileSystemRights.Modify, AccessControlType.Allow);
fs.AddAccessRule(ar);
it doest not work,,
thanks in advance
best regards
hello
|
|
|
|
|
Hi folks,
I am new to the sharepoint 2007 and i would like to create blog site using sharepoint API in my C# application.Please give the URLs or code snippet to create blog site using sharepoint API.
Thanks in advance.
Kiran Kumar.CH
(MCP)
|
|
|
|
|
Hi
I am using Visual Studio 2005 and C#. In my Windows application I load data from database into a DataSet. Is there a way to determine which DataRow in a DataTable caused an error when you update the database via a DataAdapter? What I would like to do is display to the user a short report when the update fails so that he can see which DataRow caused a problem.
Thanks.
Kobus
|
|
|
|
|
there is a datatype of varchar(max) in an input parameter of a stored procedure in sql server 2005 that I am using.
What datatype should I pass via C# to sql server for this varchar(max)?
This is what I have at present but it does not work.
param = comm.CreateParameter();
param.ParameterName = "doc";
param.Value = strXML;
param.DbType = DbType.AnsiString;
param.Size = 50000;
comm.Parameters.Add(param);
|
|
|
|
|
I have a usercontrol in form1 which has a button in it. When user press this button I create a FORM class and add my usercontrol to it with the code below:
private void MaximizeButton_Click(object sender, EventArgs e) {
Form form = new Form();
Control c = this.Parent;
form.Controls.Add(c);
form.Controls[0].Dock = DockStyle.Fill;
form.Controls[0].Location = new Point(0, 0);
form.ShowDialog();
}
The second form shown correctly but the problem is the UserControl disappear from the main form. Any idea?
Thanks
Mazy
"This chancy chancy chancy world."
|
|
|
|
|
hi,
you add contol to form,,you should add user control to form .
<br />
private void MaximizeButton_Click(object sender, EventArgs e)<br />
{<br />
userControl1 c = new userControl1();<br />
c.Dock = DockStyle.Fill;<br />
c.Location = new Point(0, 0);<br />
Form form = new Form();<br />
form.Controls.Add(c);<br />
form.ShowDialog();<br />
}<br />
|
|
|
|