meaning of syntax

Question

0.00/5 (No votes)

See more:

ASP.NET

m nw in asp.net plzzz tel me d meaning of syntax:

cmd.connection=con;

n where to use it??? :sigh:

Posted 25-Jun-10 2:36am

shahina gupta

Add a Solution

4 solutions

Solution 1

Firstly, Use proper words, please, the, etc.

This code snippet looks like a SQL command object has been instanced and assigned to cmd.

A data connection has been instanced and assigned the name con.

So, the command object is being told which connection is being used.
cmd.connection=con;

Giventhe fact there is a ; at the end would suggest that this has also been coded using C#.

Happy?

Posted 25-Jun-10 2:49am

DaveAuld

Solution 4

this example show you what this mean : http://www.java2s.com/Code/VB/Database-ADO.net/Connectionstatechangeevent.htm

and try to use VB.Net to C#[^] for you got :

32	        con = new SqlConnection("Server=(local)\\SQLEXPRESS;Initial Catalog=MyDatabase;Integrated Security=SSPI");
33	 
34	        SqlCommand cmd = new SqlCommand();
35	        cmd.CommandText = "SELECT TOP 5 FirstName, LastName FROM Employee";
36	        cmd.Connection = con; // YOU ARE HERE ^_^
37

Posted 25-Jun-10 4:35am

Adrabi Abderrahim

Comments

Sandeep Mewara 25-Jun-10 11:16am

Reason for my vote of 1
OP is a beginner and posting these stuffs would not lead him anywhere!

#realJSOP 25-Jun-10 12:28pm

@sandeep - sometimes the answer isn't suitable for beginners...

Adrabi Abderrahim 25-Jun-10 12:47pm

O_O aw! this just copy/paste any beginners can do it easily? if he know this used for SQL, can known his way? (what's needed to be searched)

Adrabi Abderrahim 25-Jun-10 12:53pm

^_^ okay! I admit my fault!

shahina gupta 26-Jun-10 8:27am

ya i have just started ASP.NET from last one week plz guide me in this field i find it quite difficult to approach it....

Adrabi Abderrahim 26-Jun-10 9:26am

I don't know if you know bit about SQL!

cmd.connection=con; used for setting connection of your SQL Server (for example).
if you want execute sql query(1) like "select * from MyTable", you need to set where's your server?
for this, you create connection (location(2) of your sql server), and you says to your query(1) to be executed in this location(2).

that mean! you says to cmd contain query(1) to be executed in location(2), by giving to cmd location(2) by using syntax "cmd.connection=con;"

(I'm good teacher ^_^? just kidding)

Solution 5

From your other posts, it's clear that you have just started coding!

I would suggest you to pick a good book or go through some tutorials. Learn and try basic stuffs.

Flooding with questions like this won't help you. You need to put some effort from your side.

Posted 25-Jun-10 5:16am

Sandeep Mewara

Comments

shahina gupta 26-Jun-10 8:24am

ok then plz suggest me some good books . i have read some books but they are not good enough...

Sandeep Mewara 26-Jun-10 8:43am

Pick any beginner book of good publication like Apress or O'riely for now. Not sure what you read.
Apart from them:
http://msdn.microsoft.com/en-gb/default.aspx
http://www.asp.net/
They should help you.

Google for anything you are trying on. You will get lots of material to read on.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

PompeyBoy3 · Accepted Answer · 2010-06-25T03:05:00

Solution 2

You may need to learn the meaning of basic spelling first. We can work on things such as syntax and grammar at a later date.

Posted 25-Jun-10 3:05am

PompeyBoy3

Updated 25-Jun-10 3:23am

v2

Comments

Richard MacCutchan 25-Jun-10 9:15am

grammer?

thatraja 26-Feb-11 11:09am

5!:)