asp form...........................................................

Posted by Anu_dgr8 under Others on 3/11/2010 | Views : 1689 | Status : [Member] | Replies : 14
i am sendin it again...............soryy for d....the previus post.........................................................................................................................................................

Thanks and Regards,
Hoosha Boosha



Responses

Posted by: Vuyiswamb on: 3/11/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
I want to help you but i cant read what you wrote ,because while i read i get lost, You say you have columns but i see a statement that has not commas or Fullstops so that i can know what is what. Please edit your post and take you time to explain your problem. Please dont forget this posting guidelines here

http://www.dotnetfunda.com/forums/thread1503-forum-guidelines-before-posting-or-answering-a-question.aspx

and i will be back to help you

Thank you for posting at dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: ANU_DGR8 on: 3/12/2010 [Member] Starter

Up
0
Down




I AM NOT ABLE TO FIGURE OUT WHAT CODE I NEED TO WRITE FOR THIS..CAN SOMEBODY HELP ME OUT?






















































































 Download source file

Thanks and Regards,
Hoosha Boosha

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 3/12/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Am trying to Figure out what you wrote, am trying to create your tables on my side, at first you named your tables and your field nicely and later it change i cant read what you wrote there. Script your Database and send the code to me and i will recreate it on my side and continue helping you.



Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Anu_dgr8 on: 3/12/2010 [Member] Starter

Up
0
Down
wat exactly u want me to send nw?

Thanks and Regards,
Hoosha Boosha

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 3/12/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Script your Database so that i can have the same Structure as you have on your side and after that we can speak with the same thing.

Go to SQl Managment Studio and Right click on your Database --> Script Database as --> Create to -->New Query Editor Window and send me what is outputed there and i will use it to create it on my side and i will be happy to help you easily.

Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Anu_dgr8 on: 3/12/2010 [Member] Starter

Up
0
Down
actually mine s a older version of sql.its 2003..wen i right click on my db->all tasks->generate sql script..one new window opens.is it wat u r talkin abt?

Thanks and Regards,
Hoosha Boosha

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 3/12/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Yes that is the one. One more thing, there is no such thing as SQl 2003, There is only SQl 2000 -->2005-->2008

Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: ANU_DGR8 on: 3/12/2010 [Member] Starter

Up
0
Down
nothin

Thanks and Regards,
Hoosha Boosha

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 3/12/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
ok i think this will do let me create this tables on my side and i will give you some answers

Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 3/12/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
ok i have created your code on my side and i want you to give me sample data for all those tables and i will compile a query for you

Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: ANU_DGR8 on: 3/12/2010 [Member] Starter

Up
0
Down
notin

Thanks and Regards,
Hoosha Boosha

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 3/12/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
check this , is there something wrong here , this is the interpretation of what you gave me. Because your request is coming from one table, am not sure what is your problem anymore. You have mentioned a field that does not exists in all these tables "category " , Please clerify
create table TBLSUPPLIER	

(

sup_lID int Primary Key Not null ,
sup_sCode varchar(10) Not null,
sup_sSupplierName varchar(100) Not null,
sup_sAddress1 varchar(100)null,
sup_sAddress2 varchar (100) null,
sup_sAddress3 varchar (100)null,
sup_sArea varchar (50)null,
cty_lID int Not null,
sup_sEmail varchar (50) null,
sup_sPincode varchar(10)null,
sup_sPhone varchar (50) null,
sup_sMobile varchar (50) null,
sup_sFax varchar (50) null,
sup_sServiceTax int null,
sup_sPAN varchar(50) null,
sup_sTIN varchar (50) null,
sup_sPrincipalName varchar(100) null,
sup_sDesignation varchar (100) null,
sup_sPaymentTerms varchar (200) null,
sup_sRemarks varchar (250) null
)


CREATE TABLE TBLSUPPLIERITEM
(
sui_lID INT PRIMARY KEY NOT NULL,
sup_lID INT FOREIGN KEY REFERENCES TBLSUPPLIER(sup_lID) NOT NULL ,
prd_lID INT FOREIGN KEY REFERENCES tblProducts(prd_lID) NOT NULL,
sui_dRate INT,
uom_lID INT FOREIGN KEY REFERENCES tblUOM(uom_lID) NOT NULL ,

)


CREATE TABLE TBLPRODUCTS
(
prd_lID int PRIMARY KEY Not null,
prd_sName varchar(50) Not null
)

CREATE TABLE TBLUOM
(
uom_lID int PRIMARY KEY Not null,
uom_sName varchar(25) Not null
)




Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: ANU_DGR8 on: 3/15/2010 [Member] Starter

Up
0
Down
tx

Thanks and Regards,
Hoosha Boosha

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 3/15/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
wow nice , Glad to hear that

Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response