Hi, I m having three store procedures 1. Test_1 2. Test_2 3. Test_3 in Test_1 i get output of one date in Test_2 i user Test_1 to get output of one week in Test_3 i want output of 7 weeks so for that when i use Test_2 in Test_3 i got error "Insert exec statement cannot be nested" please help me out of this. Thank you.
mihirhp
Posts
-
SQL 2005 Problem : Insert exec statement cannot be nested -
Other option for UpdatePanel?????hello.... I m developing one web site in which i want donot want to use updatepanel is is there any other option like javascript or else..... please help me.
-
SSO AuthenticationHello ... friends .... I have following problem .... I have two applications one is win application and other is web application ... now if one user logged in using username & password in win application and through this win application if he/she want to visit site then they have to relogin in site but i want that they can login on site using that username & password which he/she had entered earlier. that means the user will be authenticate only once so they have to give there username & password twice or more as if they move from site to win application back ... p;ease help .. me .. thanking you in advance ... Mihir
-
Other Options for static variablesHello,, Good Morning .... I am facing the following problem .... I have some static variables on my aspx page .... because i have to use them after postback on same page.... but this static variables will be same for across the session so all user get same value ... at a time but i want this variables user depandent ... i.e. every user has its own static variable ... help ... Thanking you ...
-
Add Group in ReportHi.... I an having problem ... I have to create one report in VS 2005. I had created one dataset which will return one table.... this table containt & fields, as follows MovieName, ShowTime, ScreenNo, TicketClass, ClassPrice, TotalSaleTicketforClass, TotalAmt Here there are two classes Silver, Gold..... Now the problem is I have to create group for TicketClass. also for one movie, there are four ShowTime, and each show has 2 Screen..... so how to make Groups such that I can view list of movie by TicketClass...
-
bulletedlist controlhi.... sorry for late reply.... here u r selecting filepath in query.... so, .. your data reader will give you only path of that file... if you want to open u need to download on client machine .. at that time it will give option for save or open file.... OR .................. OR ............... OR ............. Use System.IO and using this class create streamreader and read file .... ..... Try ... this.... - Best of work...........
-
Help Me......Hello.... I am having following problem... I want to know in run time which method of which class is running ie. class MyClass { public string GetName() { string className = ?; string methodName = ?; return className + methodName; } } ....... Help quick.....
-
Master Page Images GoneHi..... use tag and take ImageUrl = "~/ImageFolder/FileName" Try this....
-
Length of two dimensional !!!!!!!!hello..... I had crated one array dynamically from database..... nwo i want to know the dimesion of each column.... i.e. Here I am Providing already created 2-dim array string[,] colArray = new string[,] { { "StatusID", "System.Int32", "ABC" }, { "StatusMsg", "System.String", "ABC" }, { "Size", "System.Double", "ABC" } }; colArray[i,j] what i want to know value of i and j........
-
bulletedlist controlprotected void BulletedList1_Click(object sender, BulletedListEventArgs e) { int ind = e.Index; string txt = BulletedList1.Items[ind].Text; }
-
prblem on checkboxlisthello... Try this out ... I had done in C# and convert it to vb Protected Sub CheckBoxList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) For i As Integer = 0 To CheckBoxList1.Items.Count - 1 Dim txt As String = "" If CheckBoxList1.Items(i).Selected Then txt = CheckBoxList1.Items(i).Text Select Case txt Case "A" TextBox1.Enabled = True Exit Select Case "B" TextBox2.Enabled = True Exit Select Case "C" TextBox3.Enabled = True Exit Select Case "D" TextBox4.Enabled = True Exit Select Case "E" TextBox5.Enabled = True Exit Select Case Else Exit Select End Select Else txt = CheckBoxList1.Items(i).Text Select Case txt Case "A" TextBox1.Enabled = False Exit Select Case "B" TextBox2.Enabled = False Exit Select Case "C" TextBox3.Enabled = False Exit Select Case "D" TextBox4.Enabled = False Exit Select Case "E" TextBox5.Enabled = False Exit Select Case Else Exit Select End Select End If Next End Sub
-
how to generate sequential number of certain format??hi.... i understand your qus... but want to ask following.... 1. is emp_id is same as sequential number.... 2. u have taken emp_id char(3) then why it is 01,02,..... just clear these ..... ok....
-
Please help asp Linkbuttonhello... if it is LinkButton then use Response.Redirect()/Server.Transfer() .... it is more ideal.... Try it........
-
Displaying Image From DB to Image ControlThx u .... this worked ... for me.......
-
Getting Last Day of Month:Try one of them...... 1. SELECT Datepart(dd,DateAdd(day, -1, DateAdd(month, DateDiff(month, 0, Getdate())+1, 0))) 2. Select datepart(dd,dateadd(mm,1,Getdate() - day(Getdate()))) have a nice time........
-
inserting animated gif to asp.net websiteI dont Know... Where have u put the image... but if u use Control .... it will work... Try IT...
-
Displaying Image From DB to Image Controlhello... I m facing Problem as follows.... I had created on DB in SQL server 2005..(TEST) with table (tblImage) (ImageID int, Image image)... Then created on aspx page in VS 2005 C#..... I had stored data with this page ... in DB ... (NO PROBLEM) I had Retrive DATA From DB ... in DATASET .... (NO PROBLEM) NOW IWANT TO SHOW THAT RETRIVE IMAGE IN Control on my page.... ........... Help me..... Thanking You....
-
combobox.datasource questionIf u Put all things as I shown then it wont show the problem...... Try it again is I shown....
-
combobox.datasource questionHello... Try this one..... private void Form1_Load(object sender, EventArgs e) { DataSet ds = GetDataSet(); comboBox1.DataSource = ds.Tables[0]; comboBox1.ValueMember = ds.Tables[0].Columns["empName"].ToString(); comboBox1.DisplayMember = ds.Tables[0].Columns["empID"].ToString(); } private DataSet GetDataSet() { SqlConnection conn = new SqlConnection(@"Data Source = PC6; Initial Catalog = Test; User Id = diipluser6; Password = willy007"); SqlCommand cmd = new SqlCommand("Select * From tblEmp", conn); SqlDataAdapter adt = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adt.Fill(ds); conn.Open(); conn.Close(); return ds; } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { textBox1.Text = comboBox1.SelectedValue.ToString(); //MessageBox.Show(comboBox1.SelectedValue.ToString()); }
-
DateTime FormatHello... I want to Input Date in the format dd-mm-yyy (i.e. 27-08-2007)... in Console Program.... Help..... me.....