C# Discussion Boards - CodeProject

you are inserting a record with an already existing primary key value (patientid).

I would put a break point on the insert statement check to see what the patientid is and then manually check to see if that value exists in the database

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

ok i will try for the same.

Thanks.

Hi,
I am having trouble shuffling a column out of two. This is my original table below in Ms Access.

ID_EMPLOYEE	ID_STATION
ALAD	                 DECH
FRED	                 DECI
MIKE	                 ORR
PAM	                 OR
RAK	                 ORW
RAYN	                 PROC

I would like to shuffle ID_STATION and have something different at every run. For example:

ID_EMPLOYEE	ID_STATION
ALAD	                 ORW
FRED	                 PROC
MIKE	                 DECI
PAM	                 DECH
RAK	                 OR
RAYN	                 ORR

I am using visual studio 2012 with c#.

I created a List called scheduleList in my class SCHEDULE which contains properties like sEmployeeID and sStationID . I fill the list as follow:

C#

List<SCHEDULE> scheduleList = new List<SCHEDULE>();
//Populating Schedulelist from database
           foreach (DataRow row2 in tschedule.Rows)
           {
               sEmployeeID = row2["ID_EMPLOYEE"].ToString();
               sStationID = row2["ID_STATION"].ToString();
              scheduleList.Add(new SCHEDULE(sEmployeeID, sStationID));
           }

All I want now is a code to shuffle my ID_STATION only.

modified 4-Jul-13 16:26pm.

Create a table that holds "all possible values" or "testset" that can go into the ID_STATION, use RANDOM to fetch the values for your insert.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

You could do this as below:
1. Create a new List to store all values of ID_STATION
2. Use Random class to generate a random index from 0 to upper bound value of the above List
3. Add the value corresponding to this index into a new List
4. Remove the value from the old List
5. Repeat from 2 until the old List become empty.
6. Update every record in your table
Update tableName set ID_STATION = stationList[i] where ID_EMPLOYEE = employeeList[i]

"Never memorize something that you can look up." - Albert_Einstein

I'm working on a string and I want to split my string in multiple strings.
e.g.- my string is String str = "Data + Value + object + system";

I want new strings like String str1 = "Data";
str2 = "Value";
str3 ="object";
str4 = "system";

How can I do this?

Try the String.Split method[^]:

C#

String str = "Data + Value + object + system";
String[] parts = str.Split(new[]{ " + " }, StringSplitOptions.None);
// parts == { "Data", "Value", "object", "system" }

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Are there tutorials on the internet that explain how to use "Client Application Services" in Windows Forms Applications even in offline / disconnected mode.

I DONT want users to be authenticated, or profile data be accessed through calls to the application services hosted through a web application because the application will be used completely offline but still want to do authentication and authorization using Client Application Services, NOT windows authentication.

I have gone through some of the links herehttp://msdn.microsoft.com/en-us/library/vstudio/bb398109(v=vs.100).aspx but it seems i have to specify an Authentication, Roles and Web settings service location URL but this is going to be an offline location.

At the bottom of this article http://weblogs.asp.net/asptest/archive/2008/12/11/sharing-authentication-profile-and-role-data-between-web-applications-and-windows-forms-applications-using-the-asp-net-application-services.aspx, the author says

"Note: There are also tutorials on the internet that explain how to use "Client Application Services" in Windows Forms Applications even in offline / disconnected mode"

but he doesn't refer to any of those articles

"Coming soon"

There's a HOWTO[^] on MSDN. It uses a "local data cache", which means that it's actually looking up the details in a local database.

Wouldn't it be easier to simply put some name/passwords in a normal database and authenticate against that?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

The reason i want to use the ASP.NET SqlMembershipProvider is because in the near future, an ASP.NET application will be developed off the same database and the user access rules and permissions will be required to be the same as in this win forms application.

"Coming soon"

EricCiz wrote:
an ASP.NET application will be developed off the same database

Start with the ASP.NET application; it doesn't need to do much, except allow you to login. That way it'll be easier to integrate the WinForm app on the authentication-mechanism of the ASP.NET app, since you'd be re-using the existing structure.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Hi,
I am developing an application in which various forms are available and user had to add details on that forms and save in sql.on every form i have to save 5-6 textbox data.should i use executenonquery or execute scalar. also want to know the difference between two.

You should use execute not query with insert update statement
Please refer

http://stackoverflow.com/questions/2974154/what-is-the-difference-between-execute-scalar-execute-reader-and-executenonque[^]

thanks for the help Smile | :)

private void button1_Click(object sender, EventArgs e)
{
resetLabels();

using (SqlConnection cn = new SqlConnection())
{
cn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\patientdb.mdf;Integrated Security=True;User Instance=True";
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "select convert(varchar(50),getdate(),105) as date";
SqlDataReader sdr = cmd.ExecuteReader();

while (sdr.Read())
{
date = sdr["date"].ToString();
}
sdr.Close();
setPatientidtxt();
if (updateflag)
{
cmd.CommandText = "update Patient set" +
" name=@FirstName,surname=@LastName,age=@Age,city=@City,gender=@Gender,allergy=@Allergy,phoneno=@ContactNo,consultingfees=@Fees,note=@Note,date=@Date,time=@Time" +
" where patientid=@Patientid";
cmd.Parameters.AddWithValue("@patientid",textBox1.Text);
}
else
{
cmd.CommandText = "insert into patient values" +
"(@FirstName,@LastName,@Age,@City,@Gender,@Allergy,@ContactNo,@Fees,@Note,@Date,@Time)";
}
cmd.Parameters.AddWithValue("@FirstName", textBox2.Text);
cmd.Parameters.AddWithValue("@LastName", textBox3.Text);
cmd.Parameters.AddWithValue("@Age", textBox4.Text);
cmd.Parameters.AddWithValue("@City", textBox5.Text);
//radio button

if (radioButton1.Checked == true)
{
cmd.Parameters.AddWithValue("@Gender", radioButton1.Text);
}
else
{
cmd.Parameters.AddWithValue("@Gender", radioButton2.Text);
}
if (radioButton3.Checked == true)
{
cmd.Parameters.AddWithValue("@Allergy", radioButton3.Text);
}
else
{
cmd.Parameters.AddWithValue("@Allergy", radioButton4.Text);

}

cmd.Parameters.AddWithValue("@ContactNo", textBox6.Text);
cmd.Parameters.AddWithValue("@Fees", textBox7.Text);
cmd.Parameters.AddWithValue("@Note", textBox8.Text);
cmd.Parameters.AddWithValue("@Date", System.DateTime.Now.ToShortDateString());
cmd.Parameters.AddWithValue("@Time", System.DateTime.Now.ToLongTimeString());
// here the exception error (break) is comming at ExecuteNonQuery)

cmd.ExecuteNonQuery();

button4.Enabled = true;
label11.Visible = true;
label4.Visible = true;

timer1.Start();

}

}

I am getting an error as :

"An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: Column name or number of supplied values does not match table definition."
and sequence of columns in my table is (patientid,name,surname,age,city,gender,allergy,phoneno,consultingfees,note,date,time)
i am wondering where is sequence wrong in my code. Frown | :(

.

for insert add column names before values keyword like below

SQL

cmd.CommandText = "insert into patient (patientid,name,surname,age,city,gender,allergy,phoneno,consultingfees,note,date,time) values" +
"(@FirstName,@LastName,@Age,@City,@Gender,@Allergy,@ContactNo,@Fees,@Note,@Date,@Time)";

check column name and paremeter sequence. they should math number and each columns datatype should match with parametere

Hi,
thanks for the help code worked for my project!!!
but the thing is i added "insert into patient (patientid,......)values"+
"(@Patientid,....)"; the problem is that i fire a query in sql server to check the data is saved or not it was not there.

and thouh i typed the patient id manually in form..it will be disabled when i run application.only when i made it enable it was showing no error.

Hi,
i am not getting you point. If you provide proper parameter values in SQL then it has to work in SQL as well.
By the way , if my previous posts helped you then please up vote it. (green triangular button)

The clues are actually in the names. As you have probably guessed, ExecuteNonQuery is used for executing something that is not a query, i.e. an INSERT, UPDATE or DELETE. ExecuteScalar is used to return a scalar value from a query - a scalar is simply a single value. As a scalar is a single value, it requires less code than issuing something like ExecuteReader because the value is available for you to use immediately.

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

I just realised why my DAL only uses GetTable for 90% of our work, I get the inserted/updated record returned, as almost all my tables have a view this is the simplest way of getting all the related info. Delete and processing procs are the only exception and they return ints

Never underestimate the power of human stupidity
RAH

thanks for the help Smile | :)

private void button1_Click(object sender, EventArgs e)
{
resetLabels();

using (SqlConnection cn = new SqlConnection())
{
cn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\patientdb.mdf;Integrated Security=True;User Instance=True";
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "select convert(varchar(50),getdate(),105) as date";
SqlDataReader sdr = cmd.ExecuteReader();

while (sdr.Read())
{
date = sdr["date"].ToString();
}
sdr.Close();
setPatientidtxt();
if (updateflag)
{
cmd.CommandText = "update Patient set" +
" name=@FirstName,surname=@LastName,age=@Age,city=@City,gender=@Gender,allergy=@Allergy,phoneno=@ContactNo,consultingfees=@Fees,note=@Note,date=@Date,time=@Time" +
" where patientid=@Patientid";
cmd.Parameters.AddWithValue("@patientid",textBox1.Text);
}
else
{
cmd.CommandText = "insert into patient values" +
"(@FirstName,@LastName,@Age,@City,@Gender,@Allergy,@ContactNo,@Fees,@Note,@Date,@Time)";
}
cmd.Parameters.AddWithValue("@FirstName", textBox2.Text);
cmd.Parameters.AddWithValue("@LastName", textBox3.Text);
cmd.Parameters.AddWithValue("@Age", textBox4.Text);
cmd.Parameters.AddWithValue("@City", textBox5.Text);
//radio button

if (radioButton1.Checked == true)
{
cmd.Parameters.AddWithValue("@Gender", radioButton1.Text);
}
else
{
cmd.Parameters.AddWithValue("@Gender", radioButton2.Text);
}
if (radioButton3.Checked == true)
{
cmd.Parameters.AddWithValue("@Allergy", radioButton3.Text);
}
else
{
cmd.Parameters.AddWithValue("@Allergy", radioButton4.Text);

}

cmd.Parameters.AddWithValue("@ContactNo", textBox6.Text);
cmd.Parameters.AddWithValue("@Fees", textBox7.Text);
cmd.Parameters.AddWithValue("@Note", textBox8.Text);
cmd.Parameters.AddWithValue("@Date", System.DateTime.Now.ToShortDateString());
cmd.Parameters.AddWithValue("@Time", System.DateTime.Now.ToLongTimeString());
// here the exception error (break) is comming at ExecuteNonQuery)

cmd.ExecuteNonQuery();

button4.Enabled = true;
label11.Visible = true;
label4.Visible = true;

timer1.Start();

}

}

I am getting an error as :

"An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: Column name or number of supplied values does not match table definition."
and sequence of columns in my table is (patientid,name,surname,age,city,gender,allergy,phoneno,consultingfees,note,date,time)
i am wondering where is sequence wrong in my code. Frown | :(

.

See http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx[^] for full details of SQL commands.

Use the best guess

Hi,

I am dynamically adding text to pdf file using ColumnText.ShowTextAligned method. I want to show dynamic text vertically top left. Is there any solution?

it might others help you, if you showed the code and explained what SDK/toolkit you were using to perform this task

'g'