Hi, I have to shift my database from Sql Server Management Studio 2008 to MsAccess 2007 database. SSMS is not supporting .accdb extention (asking for .mdb extention) whereas my Access has .accdb extention. How can i export the database? Any procedure to convert from .mdb to .accdb in SSMS or .accdb to .mdb in Access. After googling a lot i tried creating DNS (i don't know its purpose), but is not working. Thanks in advance.

modified on Monday, September 21, 2009 1:27 PM

hi all, i just want to know when the .net3.5 (WCF,WPF,..), ajax are released.. release dates are they available in 2007.. thanks alot in advance

hi all, i don't know whether this is right forum or not... i just want to know when the .net3.5 (WCF,WPF,..), ajax are released.. release dates thanks alot in advance

still its not working... any other suggestions.... thanks

Hi, thanks for replying... my javascript is not executing . i verified my code many times. iam unable to figure it out (why javascript is not executing). this is my entire code: protected void page_load(object sender, EventArgs e) { if(Page.IsPostBack) { TextBox2.Attributes.Add("onKeyUp", "javascript: textLength();"); } } ]]> Untitled Page function textLength() { alert("its called"); var val = document.getElementById("TextBox1").value; if (val.length == 4) { document.getElementById("TextBox2").Focus(); } }

onKeyUp="textLength(this)" >

Is everything is correct ?

Hi All, i have 4 textboxes. when the length of text in first textbox is equal to 4 then it should "automatically" change its focus to next textbox. i have set the autopostback to true but i need to click on screen to make a postback. i used onKeyPress, onKeyUp, onTextChanged but nothing is working for me... or is there any mistake in my code.. .aspx page : javascript code : function textLength() { var val = document.getElementById("TextBox2").value; if (val.length == 4) { document.getElementById("TextBox3").Focus(); } } in .aspx.cs page: TextBox2.Attributes.Add("onKeyUp", "javascript: textLength();"); is there any way to achieve this.. Thanks in Advance.

Hi All, iam using if else for updating and inserting, i need to do this for 3 tables how can i unite them using unions or join.. IF EXISTS (SELECT col1,col2,col3,col4 FROM TableB) UPDATE TableB SET col2=TableA.col2, col3=TableA.col3, col4=TableA.col4 from TableA where (TableB.col1 = TableA.col1 and TableA.Col5='no') ELSE INSERT INTO TableB (col1,col2,col3,col4) select TableA.col1,TableA.col2,TableA.col3,TableA.col4 from TableA where TableA.Col5='no'; and i need to repeat this code for TableC and TableD (along with TableA) for updating TableB. How can i unite all in one procedure.Hope iam clear if not i can...Please help... may be the solution is simple but i dont know... i tried but unable to ... i cannot use 3 sp's, i need all in one procedure Thanks in advance

hi, i didnot use from clause in the first part and used in the second part. From clause in set solved my problem thanks alot

its not working same old error multipart identifier PresidentialSuite.RoomID cannot be bound.............

yeah, it has from clause and where clause too... INSERT INTO HouseKeeping (RoomID,DateWhenFilled,DateWhenFree,TimeForHouseKeeping) select PresidentialSuite.RoomID,PresidentialSuite.DateWhenFilled,PresidentialSuite.DateWhenFree,PresidentialSuite.TimeForHouseKeeping FROM PresidentialSuite where PresidentialSuite.Available='no';

thanks for ur reply.. yes, they exist. and RoomID is primary key. and if i modify the select statement (i just added braces and no other changes) select (PresidentialSuite.RoomID,PresidentialSuite.DateWhenFilled,PresidentialSuite.DateWhenFree,PresidentialSuite.TimeForHouseKeeping) then iam getting this error: Msg 102, Level 15, State 1, Line 14 Incorrect syntax near ','.

Hi All, Iam Newbie... IF EXISTS (SELECT RoomID,DateWhenFilled,DateWhenFree,TimeForHouseKeeping FROM HouseKeeping) UPDATE HouseKeeping SET DateWhenFilled=PresidentialSuite.DateWhenFilled, DateWhenFree=PresidentialSuite.DateWhenFree, TimeForHouseKeeping=PresidentialSuite.TimeForHouseKeeping where (HouseKeeping.RoomID = PresidentialSuite.RoomID and PresidentialSuite.Available='no') ELSE INSERT INTO HouseKeeping (RoomID,DateWhenFilled,DateWhenFree,TimeForHouseKeeping) select PresidentialSuite.RoomID,PresidentialSuite.DateWhenFilled,PresidentialSuite.DateWhenFree, PresidentialSuite.TimeForHouseKeeping from PresidentialSuite where PresidentialSuite.Available='no'; Structure of both tables are not same. with this Stored Procedure, Iam getting the error... Msg 4104, Level 16, State 1, Line 4 The multi-part identifier "PresidentialSuite.RoomID" could not be bound. Msg 4104, Level 16, State 1, Line 4 The multi-part identifier "PresidentialSuite.Available" could not be bound. Iam unable to find, what the error is? Please help

Hi, I need to check the date changed, if changed i need to execute a snippet for first request after date change and for further requests another snippet executes. How do i check the date is changed? and execute snippet for first request only? Thanks in advance.

thanks a lot.. it worked... thanks once again

hi, thanks a lot for your reply, this is what i wanted, but i need the 'dt' value outside the if(session...) statement.As this is giving me "the name 'dt' doesnot exist in the current context" error. And if i create 'dt' outside this session statement, dt is initializing for every postback... foreach (GridViewRow row in GridView1.Rows) { CheckBox box1 = (CheckBox)row.FindControl("CheckBox1"); if (box1.Checked) { if (Session["MyButton_Handled"] == null) { DataTable dt = new DataTable(); dt.Columns.Add("Items"); dt.Columns.Add("Price"); Session["MyButton_Handled"] = true; } DataTable dt = (DataTable)Session["tablevalues"]; DataRow dr = dt.NewRow(); string name1 = row.Cells[2].Text; double cost1 = Convert.ToDouble(row.Cells[3].Text); dr["Items"] = name1; dr["Price"] = cost1; dt.Rows.Add(dr); GridView2.DataSource = dt; GridView2.DataBind(); Session["tablevalues"] = dt; cost = cost + cost1; Label12.Visible = true; Label12.Text = "Total Price " + cost ; } thanks,

Hi, my page postbacks many times and this button click occurs in between postbacks(one postback occurs due to button click). when a particular button is clicked for the first time, a snippet will be executed and for other clicks of same button 'this' snippet should not be executed but some other code should be executed and for all clicks(including first click) it should remember(append the values to gridview) the previous values selected. how can i achieve this senerio. IsPostBack is not applicable. Is there anyway to check clicks and save values in gridview (gridview is not in stored in DB).. hope i am clear.. any doubts on my question are welcome.... Thanks in advance

[Message Deleted]

Hi, iam getting "Must declare the scalar variable "@picbyte" error.... and i supplied the value in my code.. cmd3.Parameters["@Picture"].Value=picbyte; this is a sql code used to insert an image into database for a specific condition, which i'll retrieve in gridview.. i neednot pass the value dynamically so iam passing the value in code itself.. why iam getting this error even though i passed the value... thanks

Hi, if a condition is met, my code inserts image into a column of database table. I used below code, passing the value of picture in code, this is giving me "Must declare the scalar variable "@picbyte", i declared its value(code below).any idea why iam getting this error... string filepath = "C:\\Users\\Prakash\\Pictures\\pic.jpg"; FileStream imgfile = new FileStream(filepath, FileMode.Open,FileAccess.Read, FileShare.Read); byte[] picbyte = new byte[Convert.ToInt32(imgfile.Length)]; imgfile.Read(picbyte, 0, System.Convert.ToInt32(imgfile.Length)); SqlCommand cmd3 = new SqlCommand("Insert into " +Label7.Text+"(Picture)"+ " values(@picbyte)",con); cmd3.Parameters.Add("@Picture",System.Data.SqlDbType.Image); cmd3.Parameters["@Picture"].Value=picbyte; cmd3.ExecuteNonQuery(); thanks in advance

modified on Tuesday, January 13, 2009 4:49 PM

hi, iam using delegates... where iam calling delegate from methods(3 methods and returns single value) and the values set by these methods are used in another method. Now i need to retun 2 values from delegate with two different datatypes... i used object[] datatype, but unable to retrieve multiple values.. if is possible with what datatype delegate should be declared and how the values can be set and retrieved.. thanks in advance