|
How can i insert multiple records in the databse in C#?
Sitara
|
|
|
|
|
wrote: How can i insert multiple records in the databse in C#?
Remember you can issue just about any SQL through a SqlCommand. (You didn't specify the database technology you are using so I've assumed SQL Server)
* Supply multiple INSERT statements.
* Supply an INSERT statement with a SELECT where the resultset has many rows.
|
|
|
|
|
Wouldn't it be better to create a store procedure
1) it would reduce the messs in coding
2) store proc are efficient in performance wise.
|
|
|
|
|
Hi,
I have a very simple, yet nagging problem. I am trying to convert some string containing numbers and dots to double. The thing is that double convert (Convert.ToDouble) crashes if the string to convert contains a dot (e.g. "10.10")
Can you please help me around this problem.
Thanks
Krugger
|
|
|
|
|
You're probably running the code on a machine where the standard culture of the OS and consequently of your application usually use another decimal separator (e.g. in german os the comma), so you have to use an overload that takes an IFormatProvider providing proper culture-specific formatting information.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
Thank you.
In fact, i just figured it out myself but thank you for the tip. It indeed has to do with the locale.
Krugger
|
|
|
|
|
You can use CultureInfo.InvariantCulture to easily get a number format where the decimal separator definitely is a period.
string s = "3.1415926536";<br />
double p = double.Parse(s, CultureInfo.InvariantCulture);
---
single minded; short sighted; long gone;
|
|
|
|
|
Simple try this
string str = "10.23";
double db;
db=Double.Parse(str);
i think it might help you
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
Hi All,
How can i change/alter the data present in the data set without connecting to the database (but when i update,these changes should reflected in the database)
ayyp
|
|
|
|
|
u can do that by creating data table run time and then add or update values in that table and add it in dataset,then while saving u have to create connection with db and u can update table in db through command object.
rahul
|
|
|
|
|
Hi! I want to implement a new .dll with which you can show a new Column in the Explorer of Windows Vista. I know, that you have to use the new Property System instead of IColumnProvider, when using the .dll on Vista.
But in the MSDN you only can read an example, which includes an so called ".recipe"-file (xml). But I don't won't to define new files. At first I just want to show a new column in the explorer which shows the numbers from 1 to 10 for example. But I don't have any ideas how to implement that. I think too, it is a problem, using the example from the MSDN, cos of its C++-Code. But I need C#!
->http://msdn2.microsoft.com/en-us/library/aa969363.aspx[^]
->http://msdn2.microsoft.com/en-us/library/ms633739.aspx[^]
Can anyone help me please?
|
|
|
|
|
Hi
How to extract text from already existing captcha image.I have some captcha images(jpg format) with me,from that images i have to read the letters one by one and convert them as a string.
|
|
|
|
|
Don't cross post
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
Noone's going to give you code to implement a spambot. 
--
Rules of thumb should not be taken for the whole hand.
|
|
|
|
|
"completely automated public Turing test to tell computers and humans apart"
If you can write a proggy that does it then it is self defeating. Heck, if you can write one for any but the most trivial captcha you have a PhD.
File Not Found
|
|
|
|
|
Have you tried the methods in the System.Net.SpamTools namespace?
HTH
Russ
|
|
|
|
|
what is aggregate function...
what are they....
where we r using...
|
|
|
|
|
i think aggregate functions are sql functions to do sum,avg,count,min,max on specific table in data base.
rahul
|
|
|
|
|
Renuka Reddy wrote: what is aggregate function...
what are they....
where we r using...
What is homework?
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
An aggregate function computes a single result from multiple parameters. Examples include Average(), Count(), Max/Sum/Min...DOingHomeWORK().
Aggregate functions make computers smart. They work for people too -- if people perform them.
|
|
|
|
|
When I click a button on form1 I execute a stored procedure. How can I display the results in a datagrid on form2?
Thanks!
Illegal Operation
Making Computer Software Talk
|
|
|
|
|
u can do this by populating dataset in form1 through ur stored procedure and then
can pass that dataset to form2 through form2's constructor and can bind datagrid
with this dataset to show the results on form2.
rahul
|
|
|
|
|
you can do it by store result in delegate
Search in google (delegate C# ) and you will find what you want
|
|
|
|
|
Dear All,
I am using the below code to serialise my class object. i want to access this serialised object into another application . Please let me know how to go about it.
[Serializable]
class Sample
{
public int i = 0;
public int j = 0;
public string str = "";
static void Main(string[] args)
{
Sample objSample = new Sample();
objSample.i = 1222;
objSample.j = 5555;
objSample.str = "This is serialised data";
IFormatter formatter = new BinaryFormatter();
Stream fs = new FileStream("MyFile.bin", FileMode.Create, FileAccess.ReadWrite, FileShare.None);
formatter.Serialize(fs, objSample);
fs.Close();
Console.WriteLine("Class serialised");
}
|
|
|
|
|
Use remoting or MSMQ.
Jayant D. Kulkarni
Brainbench Certified Software Engineer in C#, ASP.NET, .NET Framework and ADO.NET
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
