Re: my values are not inserting into database - C# Discussion Boards

garga119-Jul-07 21:37

19-Jul-07 21:37

How to create a textbox in c++..? I want to create 3 textbox and a button, if u insert values to the 2 textbox(suppose 1st textbox "2" and 2nd textbox "4")and if click the button third textbox should display the reslut(2+4=6) Plse reply..

Re: Creating textbox in c++

Sathesh Sakthivel19-Jul-07 21:44

Sathesh Sakthivel

19-Jul-07 21:44

Post it in the Correct Forum.

SSK.

Re: Creating textbox in c++

T.EDY19-Jul-07 21:46

T.EDY

19-Jul-07 21:46

I'm sorry garga1,

this is c# forum, if u want to ask anything in c++ u should go to c++ forum

int a = Convert.ToInt32(Textbox1.Text);
int b = Convert.ToInt32(Textbox2.Text);

int c = a + b;
TextBox3.Text = c;

Regard,

TCim

Open Outlook window using C#

ShahzadLatif19-Jul-07 21:07

ShahzadLatif

19-Jul-07 21:07

Hi There,

I have to open Outlook window, rather specifically some particular window with in outlook using C#. For example, if a user of my application has to add a new task in the tasks list, or setup a new appointment, I want to allow my users to click on a button on Windows Form and access that particular window i.e. Add New Task Window, Add New Appointment Window etc.

I can do this using Outlook Object Library as well, but in my particular case I have to do this using the actual outlook windows. Well, if I'll be able to do that first, then i'll definitly show a list of the items in my windows form and then let the user click on a particular item and then edit in some outlook editor window.

Any help on this would be really appreciated.

Best Regards,
Shahzad

Re: Open Outlook window using C#

Amjath Rahman19-Jul-07 23:37

Amjath Rahman

19-Jul-07 23:37

these r some of the links which will solve ur problem

http://weblogs.asp.net/cumpsd/articles/89697.aspx

http://dotnetjunkies.com/Tutorial/2E1EEEAF-C78A-4A38-A830-AC204B12DF83.dcik ----> specific to ur case

With Regards
Amjath

Re: Open Outlook window using C#

ShahzadLatif20-Jul-07 18:28

ShahzadLatif

20-Jul-07 18:28

Thanks very much, Amjath, for the reply.

But, infact, I was looking something to open a specific window of the Outlook. As we can open Outlook itself by using Process class in the Diagnostics namespace. It just opens the main Outlook window, but I was looking for something which can directly open a particular window like Add New Task, Or if I select a particular task from a list it can open the details in the task editor window of the outlook.

The articles you have mentioned can help me do the stuff by coding, but I don't wanna code, I just wanna go to the specific window.

Regards,
Shahzad

my values are not inserting into database

srinivassam19-Jul-07 21:05

srinivassam

19-Jul-07 21:05

hai all ,
in database i used only one database for empid (int),username(varchar),password(varchar),status(int),usertype(varchar)
what ever i will assign that values are not inserted into database
iam getting value in text but iam not getting in query.
please see my code
<pre>
Label1 .Text =""; //for displaying in design phase
Label2 .Text ="String.Empty;";
Label3 .Text ="String.Empty";
Label4 .Text ="";
Label5 .Text ="String.Empty";
TextBox1 .Text ="empid"; //for entering
TextBox2 .Text ="username";
TextBox3 .Text ="password";
DropDownList1.DataValueField =""; //status 1 and 2
DropDownList2 .DataValueField ="usertype"; //for normal user and admin
SqlConnection con=new SqlConnection ("uid=sa;password=sa123;database=usermanagement;server=c113");
SqlCommand cmd=new SqlCommand ("insert into tbl_user_management (empid,username,password,status,usertype) values('"+ TextBox1.Text +"','"+ TextBox2.Text +"','"+ TextBox3.Text +"','"+ DropDownList1 .DataValueField +"','"+ DropDownList2 .DataValueField +"')",con);
//SqlDataReader dr;
con.Open ();
//status = Convert.ToInt32(dr["status"]);
cmd.ExecuteNonQuery();
con.Close ();

srinivas

Re: my values are not inserting into database

N a v a n e e t h19-Jul-07 21:25

N a v a n e e t h

19-Jul-07 21:25

srinivassam wrote:
"insert into tbl_user_management (empid,username,password,status,usertype) values('"+ TextBox1.Text +"','"+ TextBox2.Text +"','"+ TextBox3.Text +"','"+ DropDownList1 .DataValueField +"','"+ DropDownList2 .DataValueField +"')"

Assign this to a string variable and print that string variable before you execute. Paste the query in query analyzer and you will get the problem. Warning, Using this method you are too close to SQL Injection Attacks. Better read Colin Angus Mckay's SQL Injection Attacks[^] article and change your method.

My Website | Ask smart questions

Re: my values are not inserting into database

T.EDY19-Jul-07 21:59

T.EDY

19-Jul-07 21:59

<code>("insert into tbl_user_management (empid,username,password,status,usertype) values('"+ TextBox1.Text +"','"+ TextBox2.Text +"','"+ TextBox3.Text +"','"+ DropDownList1 .DataValueField +"','"+ DropDownList2 .DataValueField +"')</code>

Try not to do any hardcode..use stored procedure using parameter to avoid SQLInjection..i think u got an error in that code because the empid type is in integer but u inserted a string value to it ( TextBox1 .Text ="empid"; )..try to convert TextBox1.Text to integer format and make sure TextBoxt1.text is a numeric and do this on your SQLcommand(...values('"+Convert.ToInt32(TextBox1.Text) +"',etc...)

regard,

TCim

Access to another computer!

ali_reza_zareian19-Jul-07 20:56

ali_reza_zareian

19-Jul-07 20:56

hi How cani access to another computer over interner network?
i want to use it to made a chatroom like yahoomessenger!
Thanks for your help.

Re: Access to another computer!

N a v a n e e t h19-Jul-07 21:21

N a v a n e e t h

19-Jul-07 21:21

ali_reza64 wrote:
How cani access to another computer over interner network?

Using IP you can send data over network

ali_reza64 wrote:
i want to use it to made a chatroom like yahoomessenger!

First you need to write a server application that can connect clients. Server should be multithreaded to accept multiple clients. You can use TCP connection. When one client is sending request to chat with another client, you need to establish a dedicated connection between those two machines and communicate each other.

My Website | Ask smart questions

how to connect Crystal Report with db access dynmically?

help as an alias19-Jul-07 20:56

help as an alias

19-Jul-07 20:56

Hi all,
I m try to connect crystal report with database(Access) but i have no idea about it plz help if you can proide code. or any logic.

thanks in advance,

Nikesh Yadav
CSS Infotech
Gurgaon,
Haryana(India).

Re: how to connect Crystal Report with db access dynmically?

jilucorreya23-Jul-07 4:58

jilucorreya

23-Jul-07 4:58

Hi Nikesh,

To do that you have to specify the logon details. Plase refer the following link, that's for connecting to SQL Server.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1826353&SiteID=1

Problem with Crystal report

phantanagu19-Jul-07 20:20

phantanagu

19-Jul-07 20:20

Good afternoon,
I have a question that need your help
When I summarized the monthly purchase orders(PO), I got my result effectively. But, when I show the names of selected POs in Page header, first I use Crosstab, it works well. Then, I realize that the crosstab will be limited when I provide more than 20 POs. I image about a string instead of Crosstab
My problem is that if I combine the names of POs into a string and assign the string to X2 field. How should I do ?
EX: The list PO can be shown PO1,PO2,PO3,PO4,..
I use Crystal Report in VS C# 2005
Sorry about my English.
I will appreciate your help ! If I misunderstand problem, please kindly explain me well.

It seem to be a solution or an answer.

Re: Problem with Crystal report

help as an alias19-Jul-07 21:01

help as an alias

19-Jul-07 21:01

Hi,
I m try to connect crystal report with database(Access) but i have no idea about it plz help if you can provide code. or any logic.If You can help me.
Plz do so Smile | :)

thanks in advance,

Nikesh Yadav
CSS Infotech
Gurgaon,
Haryana(India).

How to write to file using FileStream class

Chintan.Desai19-Jul-07 20:12

Chintan.Desai

19-Jul-07 20:12

I have written code to write data in file with Filestream class,but the problem is, When i open the file i see data in some other format.Pls give me some help or some link, which can help me to do my task.

Regards
Chintan
www.visharadsoft.com
(Nothing is so purify as KNOWLEDGE)

Re: How to write to file using FileStream class

Michael Sync19-Jul-07 20:33

Michael Sync

19-Jul-07 20:33

Chintan.Desai wrote:
the problem is, When i open the file i see data in some other format.

What format you wanna write and what format do you get after writing?

FileStream : Read or Write Data Streams

Google[^]

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: How to write to file using FileStream class

Chintan.Desai19-Jul-07 23:30

Chintan.Desai

19-Jul-07 23:30

Thank u for reply,I wanna to write in ascii format.What i wanna is that if i write text as:
abcd
ef
gh

i want to add 123 after e, so it should look like
abcd
e123f
gh

Regards
Chintan
www.visharadsoft.com
(Nothing is so purify as KNOWLEDGE)

Re: How to write to file using FileStream class

Rudolf Jan20-Jul-07 7:12

Rudolf Jan

20-Jul-07 7:12

Use the StreamReader and StreamWriter classes. You can use then statemens like MyStream.WriteLine("Mytext"); Please check the documentation of these classes for examples.

Rudolf Heijink

binding combo box with array

monuSaini19-Jul-07 20:08

monuSaini

19-Jul-07 20:08

Hello Every body,

I had used an array to populate the combo box ,(working on windows application with c# )

I am able to populate the displayMember but I am not able to populate its value member.

I am getting folowing error:

Cannot bind to the new display member.
Parameter name: newDisplayMember

Regards,

rahul saini

Re: binding combo box with array

Michael Sync19-Jul-07 20:30

Michael Sync

19-Jul-07 20:30

monuSaini wrote:
Cannot bind to the new display member.
Parameter name: newDisplayMember

Can you show us your code?

I guess, it's not like that. isn't it?

string[] str = new string[] { "One", "Two", "Three" };<br />
comboBox1.DataSource = str;<br />
comboBox1.Refresh();

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: binding combo box with array

monuSaini19-Jul-07 20:39

monuSaini

19-Jul-07 20:39

Hi Michael,

Thanks for rplying.
I am using following code:

string[] Level = new string[] {"Level A","Level B","Level C" };
int[] LevelValue = new int[] { 0,1, 2 };

for (int i = 0; i < Level.Length ; i++)
{
comboBox.DisplayMember = userLevel[i].ToString();
comboBox.ValueMember = i.ToString();
comboBox.DataSource = Level;

}

Regards,

rahul saini

detect mouseclick in an area

cyn819-Jul-07 19:34

cyn8

19-Jul-07 19:34

Below are parts of the code that i've done, However, it does not detect the mousedown over the area or the rectangle or ellipse. Where did i do the mistake? Can anybody help?

Thanks

public class Form1 : System.Windows.Forms.Form
{
private System.Drawing.Bitmap m_objDrawingSurface;
///

/// Required designer variable.
///

private System.ComponentModel.Container components = null;

Graphics objGraphics;
Rectangle rectBounds;
Rectangle rectangle=new Rectangle(0,10,50,50);
Rectangle ellipse=new Rectangle(100,10,50,50);
private Point mouse_pos;

.................................................................

private void Form1_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
{

Point current_pos = Control.MousePosition;
mouse_pos.X = e.X;
mouse_pos.Y = e.Y;
if (rectangle.Contains(current_pos.X,current_pos.Y ))
{ MessageBox.Show("Detect rectangle", "Info", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}

else if (ellipse.Contains(current_pos.X,current_pos.Y ))
{MessageBox.Show("Detect ellipse", "Info", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}

else

return;

}
Edit/Delete Message

Re: detect mouseclick in an area

Christian Graus19-Jul-07 19:42

Christian Graus

19-Jul-07 19:42

cyn8 wrote:
Graphics objGraphics;

Why do you have a member graphics object ? I don't see how that's ever a good idea.

cyn8 wrote:
Control.MousePosition;

What is this ? Have you tried to trace it's value to see if it's what you expect ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: detect mouseclick in an area

cyn819-Jul-07 19:53

cyn8

19-Jul-07 19:53

I'm sorry, i'm just a begineer. therefore, there mayb alot of mistakes that i might have done. However, what do you suggest i can do in order to achieve the result. Assume that i need to display 3 shape(circle, rectangle and a triangle). I should be able to select any of them at one time to be drag and drop.
thanks

Last Visit: 31-Dec-99 18:00 Last Update: 20-Sep-24 19:16

Refresh

ᐊ Prev 1...8910 8911 8912 891389148915 8916 8917 8918 8919 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.