HI, this is how it worked for me INSERT INTO TABLE2 (COL1, COL2, QL_FLG, ST_FLG, PA_FLG) (SELECT COL1, COL2, DECODE(INSTR(COL2,'QL'),0,0,1) QL_FLG, DECODE(INSTR(COL2,'ST'),0,0,1) ST_FLG, DECODE(INSTR(COL2,'PA'),0,0,1) PA_FLG FROM TABLE1); Thank you so much for your help.

HI, Thank you for the reply. Actaully the data is pretty much structered... since i cannot able to show the data here with proper horizantal and vertical bars,i kept Pipe delimeter so that data of each column will be separate from each other. My source table is having rows in arround 500 - 600K using a cursor will be costly in performence point of view. Could u please suggest if there is any other alternative.

Hi, Thank you so much for your reply. Could you please find the table information clearly with each row and data separated with pipe delimeter (|). As you suggested, Group the column by Col1.. As the Col1 Information is unique.. i think it will give the same data even after grouping. SELECT COL1, COL2 FROM TABLE1 COL1|COL2 1| Tier 1 (QL) (ST) (PA) 2| Tier 2 (QL) (ST) 3| Tier 1 (ST) 4| Tier 1 (ST) (PA) 5| Tier 1 ----------------------------------------------------- INSERT INTO TABLE2 (COL1,COL2,QL_FLG,ST_FLG,PA_FLG) SELECT COL1,COL2, , , FROM TABLE1 ------------------------------------------------------ SELECT * FROM TABLE2 COL1| COL2| QL_FLG| ST_FLG| PA_FLG 1| Tier 1 (QL) (ST) (PA)| 1 |1| 1 2| Tier 2 (QL) (ST)| 1 |1| 0 3| Tier 1 (ST)| 0 |1 |0 4| Tier 1 (ST) (PA)| 0| 1| 1 5| Tier 1 |0 |0 |0

Hi, Could some one help me with loading the TABLE2 like the way it is shown below. SELECT COL1, COL2 FROM TABLE1 COL1 COL2 1 Tier 1 (QL) (ST) (PA) 2 Tier 2 (QL) (ST) 3 Tier 1 (ST) 4 Tier 1 (ST) (PA) 5 Tier 1 ----------------------------------------------------- INSERT INTO TABLE2 (COL1,COL2,QTY_FLG,STP_THPY_FLG,PRIOR_AUTHN_FLG) SELECT COL1,COL2, , , FROM TABLE1 ------------------------------------------------------ SELECT * FROM TABLE2 COL1 COL2 QL_FLG ST_FLG PA_FLG 1 Tier 1 (QL) (ST) (PA) 1 1 1 2 Tier 2 (QL) (ST) 1 1 0 3 Tier 1 (ST) 0 1 0 4 Tier 1 (ST) (PA) 0 1 1 5 Tier 1 0 0 0 Basically from Table1(COL1, COL2) i want to copy data to Table2(Col1,Col2)..while inserting, i want check if COL2 is having any specification ((QL) (ST) (PA)) accoringly flag should be updated with 1 to the respective _FLG column,if there is no specility (example : 5th row) all the _FLG columns should be updated with 0. Please let me know if there are any related posts. Thanks

HI all, Is there a way to write data(text data) to Linux directory using C#? or Help me with establishing connectivity with Linux using C# code. Regards, Yuva

Hi Sathish, call this code snippet in page_load, For confirmation btnDelete.Attributes.Add("onClick","javascript:return confirm('Are you sure to delete the records?')");

We have made our web application compactable with the tablet PC and we want to enter the data in text fields using the stylus as well as through the mouse (When i click on the TextBox a larger text field [Replacement for Tablet PC Input Panel which should take letters in digital Ink Format and should be converted to Typed Text Format For e.g. Arial, veranda] should be displayed to enter the data and the entered text should be copied in to the respective text field when we are finished). Overall I need to make the textbox (editable fields) like an Tablet PC Input Panel...Instead of dragging it every time, which is time consuming. Can you help me with this?

HI, We have an application(HealthCare Domain -- WebApplication) developed using asp.net 1.1 & SQLserver 2000 It's developed and hosted at client places ....Know the hosptal people want the Application be compatable with TabletPC and requesting the features like they want to write using the pen in the textboxes(Editable fields) which were located on the application....! Is the Technologies which we have used are compatable with the TabletPC?? I have searched for the HandWriting Recognition tool... i found some applications[all are Windows Based applications -- using INKRecognition] IS it allowed to use Microsoft.INk dll in WebApps?? Could you please suggest me the better approch..... Thanks Yuva

U have declare dthe parameter variable and assigned value for it but u don't added it to the command object MyConn.ConnectionString = SqlDataSource1.ConnectionString.ToString(); MyConn.Open(); SqlCommand MyInsCmd = new SqlCommand(); MyInsCmd.Connection = MyConn; MyInsCmd.CommandText = "INSERT INTO UserT (UserName, ...)VALUES (@UserNameP, ...)"; SqlParameter UserNameP = new SqlParameter("@UserNameP", SqlDbType.NVarChar, 50); UserNameP.Value = UserName_tb.Text; MyInsCmd.Parametrs.Add(usernameP); MyInsCmd.ExecuteNonQuery(); MyConn.Close(); this could help u....

Hi all Actually am struglling with a problem ...here i got storedprocedure named Usp_Rpt_Proc1 which accepts two arguments in datetime fomat ...when am executing it from queryanaliser it's working fine am executing it like exec dbo.Usp_Rpt_Proc1 '1/1/2001','1/1/2008' it's returning some results as output but the problem is i want to modify that perticular procedure for that i copied and pasted the functionality (same code from SP) and inplace of CREATE PROCEDURE dbo.Usp_Rpt_Proc1 (@StartDate DateTime,@EndDate DateTime) AS am declare 2 datetime variables..and passing values for them ...and finaly am executing it.this time it's not returning any output...not showing errors aswelll just showing the column names with out content.... Plz let me now the reson behind it.....(In the second case am taking the exact code ...that's for sure).........Plz help me out With regards Yuva

Hi all, I am using SQLServer2000, I am trying to insert large amount of data into column of a table but i found only part of the data getting inserted into the table. Then i have tried the following option to set the column size sp_tableoption 'testmail', 'text in row', '7000' After the above line get executed its better but still i am lagging behind to store total text .please help me some one Thanks in advance Yuva

Hi all .., in .net 2003, in the Html view with in the body there we got onload="" event which fire during the page is loding like Now we are migrating the 2003 application(Already developed) to the 2005...here we are using master pages ...In all the webpages am using master pages while doing that in the HTML view there is no body tag(and onload="" attribute) for the content pages..But it is must to call alertmsg(); while loding the page ..So plz let me have some solution to solve this scenario or send some related articles ... Thanks in advance yuva :rose:

Hi all .., in .net 2003, in the Html view with in the body there we got onload="" event which fire during the page is loding like Now we are migrating the 2003 application(Already developed) to the 2005...here we are using master pages ...In all the webpages am using master pages while doing that in the HTml view there is no body tag(and onload="" attribute) for the content pages..But it is must to call alertmsg(); while loding the page ..So plz let me have some solution to solve this scenario or send some related articles ... Thanks in advance yuva

1)u have to diclare a public propety in the usercontrol like public string propertyname() { get { return textbox1.text; } set { textbox.text=value; }} 2)refer it in the html view by making use of Registertag <%@Register tagprefix="" tagname="" src=""%> hope this will help u........or you can have a look athttp://www.codersource.net/asp_net_web_user_controls.html[^] :rose:

Check 1)have u set autopostback=true for the dropdownlist 2)in the page load event check wether it is a pageload or postback by writing like if(!ispostback==true) { } this thing may assist u....:rose:

Hi all actually on my webpage am displaying some data on the datagrid row wise...as per the project requirement am exposing the data to be editable(displaying in the text boxex) by making use of the itemtempale ...and am keeping one button outside the datagird.and while cliking on the button i am updating the entire datagrid by accepting what ever the data is modified i.e by calling like foreach(DataGridItem itm in DataGrid1.Items) { string st,st1,st2; st=((Label)itm.Cells[0].FindControl("lblAccountId")).Text; st1=((TextBox)itm.Cells[1].FindControl("AccCode")).Text; st2=((TextBox)itm.Cells[2].FindControl("Descrip")).Text; dataAdapter=new SqlDataAdapter("update AccountCode set AccountCode='" + st1 + "',Description='" + st2 + "'where AccountId=" + st,con); dataAdapter.Fill(ds,"contentTable"); } Know what the problem is...there was somany records like (100+ in the database)..if i did like this,it took a database interaction to update each row ...i.e,for the single click it will take 100+ times of database interaction... bcz of performance resion i want to avoid these interactions...i want the updation to be done by making single interaction with the database(i.e i want to handle all the datagrid data and take the updation at single time)......Plz help me out ,,or let me have some articles related to this.... regards yuva

Hi all actually on my webpage am displaying some data on the datagrid row wise...as per the project requirement am exposing the data to be editable(displaying in the text boxex) by making use of the itemtempale ...and am keeping one button outside the datagird.and while cliking on the button i am updating the entire datagrid by accepting what ever the data is modified i.e by calling like foreach(DataGridItem itm in DataGrid1.Items) { string st,st1,st2; st=((Label)itm.Cells[0].FindControl("lblAccountId")).Text; st1=((TextBox)itm.Cells[1].FindControl("AccCode")).Text; st2=((TextBox)itm.Cells[2].FindControl("Descrip")).Text; dataAdapter=new SqlDataAdapter("update AccountCode set AccountCode='" + st1 + "',Description='" + st2 + "'where AccountId=" + st,con); dataAdapter.Fill(ds,"contentTable"); } Know what the problem is...there was somany records like (100+ in the database)..if i did like this,it took a database interaction to update each row ...i.e,for the single click it will take 100+ times of database interaction... bcz of performance resion i want to avoid these interactions...i want the updation to be done by making single interaction with the database(i.e i want to handle all the datagrid data and take the updation at single time)......Plz help me out ,,or let me have some articles related to this.... regards yuva

Hi All! i have column1 which has some values in it. i want column2 to calculate the sum of the values in column1 in each cell as shown below: CL1 CL2 10 10 25 35 32 67 12 79 56 135 what is the query i need to write in order to acheive this.pl help me out.thanking in advance!!!

Or you can go through this one [http://www.dotnetjohn.com/articles.aspx?articleid=51](<a href=)[^]" rel="nofollow"> Do it:rose:...yuva

Do this ////in the delete button click CheckBox cb; foreach(DataGridItem it in DataGrid1.Items) { cb=(CheckBox)it.FindControl("CheckBox1"); if(cb.Checked==true) { string st=((Label)it.Cells[1].FindControl("Primary keycolumn name")).Text; dataAdapter =new SqlDataAdapter("delete from AccountCode where AccountId=" + st,con); dataAdapter.Fill(ds,"deleteTable"); } } DisplayRecords(); //some procedure to bind the data This should run...make modifications curructly:rose::rose: