|
I modified the above query as
INSERT INTO PatientsDetails
(FirstName, LastName, DateOfBirth, BloodGroupId, Gender)
VALUES (@FirstName,@LastName,@DateOfBirth,@BloodGroupId,@Gender);
Still its happening the same ...
Apurv
“Never trust a computer you can’t throw out a window.”
(Steve Wozniak)
“There are only two industries that refer to their customers as ‘users’.”
(Edward Tufte)
|
|
|
|
|
This may sound stupid, but are you querying the same DB programatically, and via the SQl query? Have you checked your connection string?
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
"Rumour has it that if you play Microsoft CDs backwards you will hear Satanic messages.Worse still, is that if you play them forwards they will install Windows"
|
|
|
|
|
I meant the C# code. If this query is working through management studio, it must be correct. There has to something wrong in your code.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtFirstName.Text == "")
MessageBox.Show("Patient's First Name can't be blank", "Incomplete data", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
else if (txtDOB.Text == "")
MessageBox.Show("Patient's Date of Birth can't be blank", "Incomplete data", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
if (txtLastName.Text == "")
txtLastName.Text = " ";
bool gender = true;
if (!rbMale.Checked)
gender = false;
MRMDbDataSetTableAdapters.PatientsDetailsTableAdapter pdta = new MediRecordManager.MRMDbDataSetTableAdapters.PatientsDetailsTableAdapter();
if (pdta.AddNewPatient(txtFirstName.Text, txtLastName.Text, calDOB.SelectionStart, (byte)cbBloodGroup.SelectedValue, gender) > 0)
{
MessageBox.Show("Data inserted to database !");
btnCancel.Text = "Close";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
Apurv
“Never trust a computer you can’t throw out a window.”
(Steve Wozniak)
“There are only two industries that refer to their customers as ‘users’.”
(Edward Tufte)
|
|
|
|
|
You are just adding the row to a table in your in-memory dataset. At least that's all the code you've posted does.
To save it to the database, call Update() on the data adapter created for your typed data set.
|
|
|
|
|
Are you using an access database?
If not just ignore the rest of this posting.
Some time ago, someone had the same problem with an access database.
His problem was, that he added the empty .mdb file to the project, and every time
he build his solution the empty database has overwritten the one with data in it.
Greetings
Covean
|
|
|
|
|
I am using MS SQL 2008 server database
Apurv
“Never trust a computer you can’t throw out a window.”
(Steve Wozniak)
“There are only two industries that refer to their customers as ‘users’.”
(Edward Tufte)
|
|
|
|
|
Do you use transactions (maybe indirect?)?
Thats the last idea I have for solving your problem.
Greetings
Covean
|
|
|
|
|
You have a SQL command that returns a BLOB. You are retrieving the data via a DataReader, but you are having problems using the default behavior.
Referring to the scenario above, which one of the following
CommandBehavior options, specified as an argument to the ExecuteReader method, allows you to use the GetBytes() method to retrieve the BLOB from a stream?
Choice 1
CommandBehavior.SequentialAccess
Choice 2
CommandBehavior.SingleResult
Choice 3
CommandBehavior.SingleRow
Choice 4
CommandBehavior.LargeData
Choice 5
CommandBehavior.BinaryAccess
|
|
|
|
|
Seriously, it sounds like you're posting questions from an exam. Maybe you should do your own homework! 
|
|
|
|
|
Having difficulty with your homework?
Try learning to use Google. Typing in the three relevent words from your question, the top hit was the answer.
Try and do something for yourself, will you?
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
"Rumour has it that if you play Microsoft CDs backwards you will hear Satanic messages.Worse still, is that if you play them forwards they will install Windows"
|
|
|
|
|
OriginalGriff wrote: Typing in the three relevent words from your question, the top hit was the answer.
You actually tried this! Seems you have a lot of time to kill.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
30 seconds, tops. That's only a quick type while I glug some coffee. I like to check my answers - nothing worse than wrong advice from somewhere full of "experts"!
I figured it would be near the top, but the top hit, giving the answer in exactly the words the OP used, is pushing someones "research" skill a bit, I feel...
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
"Rumour has it that if you play Microsoft CDs backwards you will hear Satanic messages.Worse still, is that if you play them forwards they will install Windows"
|
|
|
|
|
OriginalGriff wrote: I like to check my answers - nothing worse than wrong advice from somewhere full of "experts"!
I like to be on safer side. Hence my sig. 
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
There are classes that are common to both the Microsoft Oracle provider and the Oracle ODP.NET provider. While certain methods or properties will vary between the implementations, the high-level concept is generally the same.
Based on the above scenario, which one of the following CLASSes is only available in one of the providers but not both?
Choice 1
OracleInfoMessageEventArgs
Choice 2
OracleRowUpdateEventArgs
Choice 3
OracleParameter
Choice 4
OraclePermission
Choice 5
OracleBFile
|
|
|
|
|
Come on, do your own homework you lazy individual.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
|
If you add a reference to System.Data.OracleClient & the oracle odp client you will be able to find out.
Just had a quick look and the answer is OraclePermission is not in ODP.NET. If your thinking of which one to use I would vote for ODP.NET as the latest version allows you to map oracle objects to your own objects
The FoZ
|
|
|
|
|
Hi, I have a decimal number. I need to convert this decimal value to exponential value. I have a vb.net code to convert from decimal to exponential value is Format(100000, #.0#E-##) . When I run this code in vb.net it returns 1.0E5
I need the same expression for the c#.
I am using the following code String.Format("{0:E}", 100000) and its returns 1.000000E+005, but I need 1.0E5. The same for the another value String.Format("{0:E}", 0.000597), I need 5.97E-4 but it is returning 5.970000E-004. Does anyone let me know the right expression 
Pankaj
|
|
|
|
|
Use string.Format("{0:0.0E+00}", 1000000);.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
Thanks for your replay. When I run
string.Format("{0:0.0E+00}", 0.000597); its return 6E-04 but I need 5.97E-4. I do not want to round the number.
Pankaj
|
|
|
|
|
I have done some small changed in the expression and got the near of correct result
string.Format("{0:0.0E2}", 0.000597); then its returns 5.97E-004. Can we remove 00 after the E ?
Pankaj
|
|
|
|
|
Got one solution
string.Format("{0:#.0#E-00}", 1000000);
Pankaj
|
|
|
|
|
I have two table Employee and EmployeeAddress and Both Cotain ID filed with integer, I want to Join both in DataSet How can i do it ???
select * from Employee, EmployeeAddress where Employee.ID= EmployeeAddress.ID
I want to do the the above sql operation in my Dataset & need to display in girdview
My Dataset Contain two Table one is for Results of Employee another table contains details of EmployeeAddress. How can Provide First Table as Primary and Second Table as Forign Key
I tried that
Dataset objds=new Dataset();
......
......
//Analyse that Dataset contain two tables of data now then How can I provide relation and need to give to Gridview
objds.Relations.Add("Relation",objds.Tables[0].Column["ID"],objds.Tables[1].Column["ID"]);
Gridview1.Datasource = objds;
Gridview1.DataBind();
But it showing only First Table Data only I want to Join both tables as one and need to show in Gridview How can do It ?
Regars,
Shaik Haneef
sk.haneef@gmail.com
|
|
|
|
|
I don't think the GridView supports this, but you can try adding databound columns at design-time, this might permit you to bind some columns to the first table and some to the second. I doubt it tho.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
