|
Hi,
I understand what you are trying to say, but it's not making any sense in what I am trying to do.
I have the following SQL statement in a stroed procedure:
SELECT
OrderItemID_PK,
WineID_FK,
OrderItemUnitPrice,
OrderItemQty,
OrderID_FK
FROM
OrderItems
WHERE
OrderID_FK = @OrderID;
I only need the wine ID to populate the Wine object. In my DA class I did it like this:
// Do connections and stuff here
while (dr.Read())
{
OrderItem objOrderItem = new OrderItem();
// Populate other fields
Wine objWine = Wine.GetWineByWineID(dr.GetInt32(1)); // Related Wine object
objOrderItem.OrderItemWine = objWine; // Required
}
OrderItemWine is a property in the OrderItem class that sets the Wine object. I declared the Wine object in the OrderItem class like this:
private Wine m_Wine;
And the property that sets this Wine object in the OrderItem class is:
public Wine OrderItemWine
{
get { return m_Wine; }
set { m_Wine = value; }
}
Like this I can retrieve Wine information, now how do I get the wine name into my gridview, if I didn't define a Coloumn as such for the DataField property??
Please help. I hope it is more clearer.
Regards,
ma se
|
|
|
|
|
You can try and add a separate function into the datafield template, that calls the name of the wine, using the id you got from the select query, for that specific field.
EG: As the following into your
GetNameForID(wineID) //Id for the wine name you want to add here
or how about using parent/child relationship repeater or datagrid?
|
|
|
|
|
Hi, Could anybody help me to extract Metadata about Flash Video File .flv file. i.e. how to extract details about a particular flv file.
Thanks in Adavnce..
|
|
|
|
|
How to register an assembly in asp.net web app?
How to register an assembly in asp.net web app?
How to re gister an assembly in asp.net web app?
|
|
|
|
|
Hi all
I am trying to insert data in .mdb file
I have 20 fields
If i insert 6 fileds it is working
But it is not working when i try to inserting 20 fileds
It is giving this error
"Syntax error in INSERT INTO statement."
Can any one help me
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
What is the code?!
|
|
|
|
|
Pls check the Names of the Column in the DB and Also in ur code.
With Regards
Satips
|
|
|
|
|
Satips wrote: Pls check the Names of the Column in the DB and Also in ur code.
I think you replied to the wrong person. I did not ask the original question.
|
|
|
|
|
It has nothing to do with the number of fields. You have just made an error when adding the other fourteen fields.
That is about as much as anyone can say without seeing the actual code.
---
b { font-weight: normal; }
|
|
|
|
|
Hi
Sorry all of u
Actiually i didnt post my second error
Some times It is giving "Unspicified Error" in connection.open()
Or it is giving "Syntax error in INSERT INTO statement"
And i chk the insert statement also no errors in that
Plz chk my code
MYCODE
----------
Dim sConnectionString
Dim objCmd As New System.Data.OleDb.OleDbCommand
sConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Some.mdb") & ";")
Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString)
objCmd.Connection = objConn
objCmd.CommandText = "INSERT INTO Info(1,2,3,4,5,6,----------------20) values('" & 1.Text & "','" & 2.Text & "','" &
3.Text & "','" & 4.Text & "','" & 5.SelectedItem.Text & "','" & 6.SelectedItem.Text & "',--------------------- up to 20
fields)"
objCmd.Connection = objConn
objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()
THX
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
No, that is not the code that you are using. You can not use numbers as names of objects, so it won't even compile. Also, you can not use numbers as field names in the database like that.
If you don't want to post the exact code that you are using, put together a working example that demonstrates the problem. There is no point in trying to find an error in a piece of code that is different from the code where the actual error is.
---
b { font-weight: normal; }
|
|
|
|
|
Hi
My mean is not hide the code my fields name are to big thats y i put fields name as numbers to better understood
Plz chk this
MYCODE
---------
Dim sConnectionString
Dim objCmd As New System.Data.OleDb.OleDbCommand
sConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Names.mdb") & ";")
Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString)
objCmd.Connection = objConn
objCmd.CommandText = "INSERT INTO
Info(username,userpasswd,Name,email,try,loc,other,other1,num,yearwise,monthwise,skils,funarea,current,ug,pg,greatpg,RB,ugo
ther,pgother,postother,cpr) values('" & uname.Text & "','" & pass.Text & "','" & name.Text & "','" & email.Text & "','" &
c***ry.SelectedItem.Text & "','" & loc.SelectedItem.Text & "','" & other.Text & "','" & other1.Text & "','" & no.Text & "','"
& yearwise.SelectedItem.Text & "','" & monthwise.SelectedItem.Text & "','" & skilsmen.Text & "','" & Label1.Text & "','" &
currrent.SelectedItem.Text & "','" & ugrad.SelectedItem.Text & "','" & pggrad.SelectedItem.Text & "','" &
pggreat.SelectedItem.Text & "','" & RB.SelectedItem.Text & "','" & u1.Text & "','" & p1.Text & "','" & greatpg1.Text & "','"
& cpr.Text & "')"
objCmd.Connection = objConn
objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
That's better. The problem is in the information that you left out in the previous post.
"Name" is a reserved keyword in Access.
"Current" is a reserved keyword in SQL, Jet and ODBC.
---
b { font-weight: normal; }
|
|
|
|
|
HI
I changed DB fileds still it is giving same ERROR
Plz Chk this code
MYCODE
---------
Dim sConnectionString
Dim objCmd As New System.Data.OleDb.OleDbCommand
sConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("DB22.mdb") & ";")
Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString)
objCmd.Connection = objConn
objCmd.CommandText = "insert into user(uname,pass) values(" & TextBox1.Text & "," & TextBox2.Text & ")"
objCmd.Connection = objConn
objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
User is a reserved keyword.
---
b { font-weight: normal; }
|
|
|
|
|
Thx
I got it
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
Hi,
i want to write a javascript function in .aspx file to
make a button enable property false and i want to take the value from a textbox to a javascript function and also i want to put some values in a textbox using javascript function.i tried a lot .but i didn't get the correct code.i know the same in asp .but in asp.net 1.1 that code is not working
Please give me a reply.
Thanks and regards
anu
|
|
|
|
|
What exactly have you done? Or what error are you getting?
Best Regards,
Apurva Kaushal
|
|
|
|
|
instead of making textbox enable false make it readonly
Mahendra
|
|
|
|
|
Is your web control or HTML control ?
html Element has not property "readOnly"
if use javascript to control a button enable property that I don't know
Haha..,sorry,I can't help you
WWF Let our word health and happy
|
|
|
|
|
hi dear friends,
I want to validate asp.net2 web controls (<asp:textbox>) by javascript but
but it can not recognized.(document.form1.TextBox1.value)
the other point is that content pages dont have form tag, this tag is just in master page while my controls are placed in content page.
Please refer me to helpful sites about this case.
thank you
Regards
yousefi
Tehran-Iran
zahra yousefi
yousefi105@yahoo.com
|
|
|
|
|
actually when u use masterpage concept asp.net add pageid before each control so for accessing any control from javascript prefix pageid with control
u can check pageid by viewsource of your file
Mahendra
|
|
|
|
|
hello!
i have problem to create new asp.net web applicatio with VC++ or C#.
what settings should be set for my project or iis service?
-- modified at 7:00 Tuesday 12th September, 2006
Zo.Naderi-Iran
|
|
|
|
|
Are you using Visual Studio 2005 or 2003 ?
|
|
|
|
|
How can I provide permissions to shared Drive or Network Drive folders from asp.net Page?
Any help plz??????????????
Thanks,
Bhasker P
|
|
|
|