hi all..
i have 3 tables called itemMaster,Item Wh,whWiseItem(t able names i took just for example). here i want to retrieve data from all the 3 tables.
table details
itemMaster having details of Item means Code,Descriptio n,UOM etc.
ItemWh-items fro perticular store.
whWiseItem-also transactions for perticular store with item code
what i want is, i want to take items details from itemMaster...
buterfly0707
Last Activity: May 15 '11, 08:23 AM
Joined: Nov 13 '09
Location:
-
How to combine three tables using a Join?
-
Remove the current row from datagridview
hi..
i want to remove the current row in the data grid how can i do this. and i wants to write this in cell enter event.
what i am doing here is in cell enter event in the data grid i am checking weather the the entered value is already there in the database. if it so i am clearing that entered value and wants to remove that row. here i don't know how to remove this row.
i want to write the code in cell enter... -
Remove the current row from datagridview
hi..
i want to remove the current row in the data grid how can i do this. and i wants to write this in cell enter event.
what i am doing here is in cell enter event in the data grid i am checking weather the the entered value is already there in the database. if it so i am clearing that entered value and wants to remove that row. here i don't knowhow to remove this row.
i have used:
dgvItem.Rows.Re moveAt(dgvItem. CurrentRow.Inde x);... -
Datagrid validation..
hi..
i want to check weather datagrid particular cell is empty. whet i wan to do is :
if in a datagrid row if 1st 2 cells are not null and if i did not enter a value to 3rd cell then i go to enter new values to next row then i want o give error fill the 3rd cell.
so far what i did was:
here dgvItem is my datagrid. i have written this code in cell_enter event
...Code:try -
Thank You : ThatThatGuy -
i
Yes, im using Datagrid view. im sorry, what i wanted to know is how to do this validation part??
Can you tell me how i can validate the particular cell value. i mean the method??
thanks...Leave a comment:
-
Datagrid cell's Numeric Validation
I want validate a separate cells in datagrid. if i want only numbers in a particular cell in the datagrid how can i do it.
for example :
There is datagrid with 3 columns. ID,Name,Phone number
I want to validate this phone number field. if user enter a some other values than a number i want to give a error message.
This may be a easy task as im very new to c# please someone help me with this... -
converting the date..
hi..
i want to convert date to sql date format for insert to the database table. i hav edone it like this.
...Code://converting date public DateTime Get_Date(string G_date) { string New_date = ""; try { string[] Date = G_date.Split('/'); stringLeave a comment:
-
covert to system date format
hi ...
assume computer system date format is mm/dd/yyyy
but the format which SQL is getting dd/mm/yyyy. and from the c# code by sql query i have to convert the date to sql datetime format to insert the date to database table . but when i do this im getting an error as
"invalid date format". and if i get the date as mm/dd/yyyy den also from query i cannot insert it to database table.
what i want... -
i figured this out. thanks for all.
ThatThatGuy: thanks.
mzmishra : thanks for reply. yah no need of datatable here.Leave a comment:
-
Insert the textbox value to database and retrive it to List Box
hi evryone..
i want to get the text box value to list box .
And also i want this textbox value enter into the dabasex table called Area and @ th esame time insert this value to List box. here is the code wich i have use.
...Code:SqlConnection conn = new SqlConnection(ConnectionString); String S = "Insert into Area values ('" + textBox1.Text.ToString().Trim() + "')"; -
Thank you very much. it worked...Leave a comment:
-
Add multiple items from ListBox to TextBox
hi..
i want to add selected multiple items form list box to text box(MultiLine) seperated with a comma in each item.I know how to add multiple list box values to another List box. but how can i add for the text box.
it will be a grate help if some one can help me with this.
thank you. -
Add multiple items from ListBox to TextBox
hi..
i want to add selected multiple items form list box to text box(MultiLine) seperated with a comma in each item.I know how to add multiple list box values to another List box. but how can i add for the text box.
it will be a grate help if some one can help me with this.
thank you. -
data in dataset is not coming to the cryatal report
hi everyone....
tto my dataset it filling the correct records. but its not comming to the crystal report. means the records in crystal report is incorrect. in cryatal report all the recordes in database is coming not the given period.
what will be the wrong im doing here??
<code>
SqlConnection conn = new SqlConnection(C onnectionString );
SqlCommand command = new SqlCommand();... -
thank you it worked nicely.Leave a comment:
-
Give a range in a query
hi..
i want to kow wether can we give a range in sql.
maens i want to get the values in field where one period to another period.
example:ther is two fields in the table period and data. i want to get all the values in data field acccording to given period value (like 1 to 3) how can i do this??
thank you in advance -
To Get sum of field in crystal report
hi i have some problem while getting the sum of the field. i want to get the sum of one filed for example sum of the values which in Debit Field. but i want to get this sum according to another field called period. means for that respective period value i want the sum of the Debit field in crystal report. and im using a dataset.in this dataset there s both the fields
here, i know...Leave a comment:
-
To Get sum of field in crystal report
To Get sum of field in crystal report
hi
i have some problem while getting the sum of the field. i want to get the sum of one filed fro example Debit. but i want to get this sum according to another field called period. means for that period value i want the sum of the debit field in crystel report. and im using dataset.
here i know how to get the sum of the debit fild by adding the Fomular field. but i dont know how... -
Thanks fro your help...Leave a comment:
No activity results to display
Leave a comment: