ranjana1980
Last Activity: Jul 17 '08, 01:35 PM
Joined: Jul 10 '08
Location:
-
I use your stored procedure code to update two tables but i get error in where clause... -
Hi, how to Deploy desktop application
How to deploy our desktop application in Dot Net with database
what Steps to Deploy Desktop application in Dot Net -
Hi,
Thanks For this Solution.Your Previous three point I have clear regarding error.
I like to update different values of both the tables having same regno of both tables.
Can I Solve this using trigger but I don't know how to update two tables with different values with having same RegNo using trigger...Leave a comment:
-
Its my mistake i wrote double equal actually I will try with single equal to and i face same problem...Leave a comment:
-
I have an error where i using as clause...Leave a comment:
-
Hi,Problem in crystal report
Here Sample Of my crystal Report Using Eg
In My crystal report,I retrieve data from two tables using sql-server using this code
...Code:con.ConnectionString = "Data Source=XPO3;Initial Catalog=Imsapplication;Integrated Security=True"; con.Open(); adp1 = new SqlDataAdapter("select * from phototab", con); DataSet ds1 = new DataSet(); adp1.Fill(ds1, "phototab"); adp2 -
update Student as s,AcademicQuali fication as a set s.FName='Maya', s.LName='Sharma ',a.InstituteNm ='St Joseph',a.Unive rsity='Barkatul lah' where s.RegNo==a.Regn o...Leave a comment:
-
c#.net save image in database
In my project of desktop application using c#.net save image in database during registration of student But it is not mandatory.Witho ut Browse the image i click on insert button it gives error "Empty path name is not legal".
...Code:con.ConnectionString = "Data Source=XPO3;Initial Catalog=Imsapplication;Integrated Security=True"; con.Open(); //Cryclass cc = new Cryclass(); -
Update record of two table
How to update record of two tables when in Table A RegNo is primary key
and in Table B RegNo is foreign Key and i like to update where A.RegNo=B.RegNo -
simple update statement using two tables not work .
update Student as s,AcademicQuali fication as a set s.FName='Maya', s.LName='Sharma ',a.InstituteNm ='St Joseph',a.Unive rsity='Barkatul lah' where s.RegNo==a.Regn o...Leave a comment:
-
Update Record in two Table using trigger
Hi All,
I have two tables One is Student And another is AcademicQualifi cation.In first table RegNo is primary key and in second one it is foreign key then how to create trigger to update table where Student.RegNo = AcademicQualifi cation.RegNo -
Yes,I mean multiple records.
To View such report is it require to take subreport for second table?...Leave a comment:
-
I Like to view from table B in crystal report in following format:
Id Qualification Univrsity Percentage
r001 10th MPBoard 66
r001 12th MP Board 70
r001 Graduation Gujarat Univ 67
But in table A Id is primary key and in table B Id is foreign key....Leave a comment:
-
string connString = System.Configur ation.Configura tionSettings.Ap pSett ings.Get("Conne ctionString");
string query = "Select * from SaleReceipts";
conn = new OleDbConnection (connString);
conn.Open();
da = new OleDbDataAdapte r(query, conn);
dataset ds = new dataset(); ...Leave a comment:
-
crystal report
how to get data in crystal report using two tables while in table A one filed is primary key and in table B same field as foreign key.And in Table B the foreign key has multiple record of same id.How to show it in crystal report
No activity results to display
Leave a comment: