Comments by varuncodee

varuncodee 24-Mar-18 8:04am View

i am getting error while saving image in database. i am getting this error "Could not save; currently locked by another user." at cmd.ExecuteNonQuery(); line.

varuncodee 24-Mar-18 7:15am View

Yes that's big mistake, Thank's. i corrected it now i am using cmd.ExecuteNonQuery(); but still getting that error again.

varuncodee 6-Aug-17 12:18pm View

i tried visual studio wizard for connection and it works. But manually by code it's not working.

varuncodee 6-Aug-17 12:17pm View

Still not working.

varuncodee 6-Aug-17 11:54am View

At first they were using DD-MM-YYYY format so all date store in database in same format and after sometime somebody by mistake changed system date format to MM/DD/YYYY so database contain to different type of format. so they are facing problem when to type of date show in crystal report or when they search some record by date it won't give result after date is changed.

varuncodee 24-Apr-16 8:41am View

Thanks Karthik code worked like a charm. my problem is solved, now i am trying to understand the code ... Thanks

varuncodee 24-Jan-16 5:50am View

ohh!! my mistake.. thank you...

varuncodee 21-Jun-15 13:36pm View

sir this code works, but i don't know why my previous query was not working, please tell me if you found what was the problem. thanks

 OleDbCommand cmd = new OleDbCommand("select * from Salary where (GPFCPF=? AND NameOfUnit=? AND GPFcategory=? AND PoNo1 <> ? OR PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ? ) AND (SDATE BETWEEN @date1 and @date2) ORDER BY SlipNo ASC", con);

varuncodee 21-Jun-15 13:16pm View

Sir i want to get result on the basis of date (SDATE BETWEEN @date1 and @date2)
other conditions are working fine expect date condition

varuncodee 21-Jun-15 13:01pm View

Deleted

 using (OleDbConnection con = new OleDbConnection(ConfigurationManager.AppSettings["connection"]))
                    {
                        con.Open();
                        crystalReportViewer1.Refresh();
                        CrystalReportLIC billbyday = new CrystalReportLIC();
                     OleDbCommand cmd = new OleDbCommand("select * from Salary where GPFCPF=? AND  NameOfUnit=? AND GPFcategory=? AND SDATE BETWEEN @date1 and @date2 AND PoNo1 <> ? OR  PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ?  ORDER BY SlipNo ASC", con); 
                        OleDbDataAdapter da = new OleDbDataAdapter();
                        da.SelectCommand = cmd;
                        cmd.Parameters.Add(new OleDbParameter("@GPFCPF", comboBox1.Text));
                        cmd.Parameters.Add(new OleDbParameter("@NameOfUnit", comboBox3.Text));
                        cmd.Parameters.Add(new OleDbParameter("@GPFcategory", comboBox4.Text));
                        

                        cmd.Parameters.Add(new OleDbParameter("@p1", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p2", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p3", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p4", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p5", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p6", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p7", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p8", ""));


                        cmd.Parameters.Add(new OleDbParameter("@date1", Convert.ToDateTime(dateTimePicker1.Text)));
                        cmd.Parameters.Add(new OleDbParameter("@date2", Convert.ToDateTime(dateTimePicker2.Text)));

   
                        DataSetSalary ds = new DataSetSalary();
                        da.Fill(ds, "Salary");
                        billbyday.SetDataSource(ds);
                        crystalReportViewer1.ReportSource = billbyday;
                        con.Close();
                    }

varuncodee 21-Jun-15 12:59pm View

Deleted

Sir this is my whole code

varuncodee 21-Jun-15 12:58pm View

Deleted


using (OleDbConnection con = new OleDbConnection(ConfigurationManager.AppSettings["connection"]))
                    {
                        con.Open();
                        crystalReportViewer1.Refresh();
                        CrystalReportLIC billbyday = new CrystalReportLIC();
                        OleDbCommand cmd = new OleDbCommand("Select *, (select * from Salary where GPFCPF=? AND  NameOfUnit=? AND GPFcategory=? AND PoNo1 <> ? OR  PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ? ) as sub_salary  form Salary where SDATE BETWEEN @date1 and @date2 ORDER BY SlipNo ASC", con);
                        OleDbDataAdapter da = new OleDbDataAdapter();
                        da.SelectCommand = cmd;
                        cmd.Parameters.Add(new OleDbParameter("@GPFCPF", comboBox1.Text));
                        cmd.Parameters.Add(new OleDbParameter("@NameOfUnit", comboBox3.Text));
                        cmd.Parameters.Add(new OleDbParameter("@GPFcategory", comboBox4.Text));
                        

                        cmd.Parameters.Add(new OleDbParameter("@p1", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p2", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p3", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p4", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p5", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p6", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p7", ""));
                        cmd.Parameters.Add(new OleDbParameter("@p8", ""));


                        cmd.Parameters.Add(new OleDbParameter("@date1", Convert.ToDateTime(dateTimePicker1.Text)));
                        cmd.Parameters.Add(new OleDbParameter("@date2", Convert.ToDateTime(dateTimePicker2.Text)));

   
                        DataSetSalary ds = new DataSetSalary();
                        da.Fill(ds, "Salary");
                        billbyday.SetDataSource(ds);
                        crystalReportViewer1.ReportSource = billbyday;
                        con.Close();
                    }

varuncodee 27-Feb-14 3:08am View

thank you sir,
could you please give me a example?

varuncodee 2-Feb-14 7:30am View

yes sir that's very strange design but i can't find any other idea.
Sir actually i am developing school project, my project is to develop software for retail shop where counter person can feed(sell) any number of item .
Coming to my project if i place textboxs on my form at design time it will fix the number of item to be sell.
Please suggest some idea or code.. thanks for your reply

varuncodee 31-Aug-13 7:33am View

sorry but how can i use productid as group because i use productname as group so value will not repeat ..

varuncodee 31-Aug-13 6:53am View

thank you soo much for d reply :)
i use this formula
sum(GroupName ({SellProduct.P1Name}),{SellProduct.Price})

my price field is integer .. but when i got error "a number field or currency field is required here" The "GroupName ({SellProduct.P1Name})" field got highlighted and this "GroupName ({SellProduct.P1Name})" field is string ..

varuncodee 31-Aug-13 6:25am View

when i try this formula i get error ..it says "a number field or currency field is required here"
even Price field is number field.

varuncodee 4-Aug-12 13:12pm View

Thanks Santhosh .. i don't want to use girdview, I am trying to develop test engine and i want record one by one in text boxes i have next and prev button to navigate through the question's
.. please help..

varuncodee 4-Aug-12 13:08pm View

Thanks Wes Aday for reply... so how can i get row one by one in textbox? that is my question.

varuncodee 29-Feb-12 2:01am View

Thanks :)

varuncodee 29-Feb-12 1:56am View

Deleted

Now using this and getting same error message :(
OleDbCommand cmd7 = new OleDbCommand("delete ProductEntery FROM(select TOP " + txtname1.Text + " * from ProductEntery)AS t1 where Produc_Name = @yo", con7);

varuncodee 29-Feb-12 1:25am View

Thanks for the reply ..error message is "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect."

varuncodee 27-Feb-12 4:41am View

just call the Class here and open the connection...

For example:
Class1 a = new Class1();
SqlConnection con = new SqlConnection(a.obj);
con.Open();

varuncodee 27-Feb-12 4:33am View

yes, not necessary if you are using class file.

varuncodee 26-Feb-12 5:11am View

In English version of visual studio it says "Suppress Blank Section" i don't know why but it doesn't work, i see your links and put this code in "Suppress(No Drill-Down)" and click on "X-2" button Formula workshop {patientdetail.test2name}="" and it works...... :D

Thank alot for helping me :)

varuncodee 26-Feb-12 5:09am View

Deleted

In English version of visual studio it says "Suppress Blank Section" i don't know why but it doesn't work, i see your links and put this code in "Suppress(No Drill-Down)" and click on "X-2" button Formula workshop {patientdetail.test2name}=""

Thank alot for helping me :)

varuncodee 24-Feb-12 9:49am View

yes sir query is correct, actually datatype of "date" Field is set to "Text" that's why query was not giving me desired result but now it's working.
Thank alot for helping me :)

varuncodee 24-Feb-12 8:44am View

Thank you very much sir.

But this query is not giving me desire result when i select dateTimePickerstart as 2/7/2011 and dateTimePickerend as 2/8/2011 and it return all records between Feb 8 to Feb 9 without matching doctor name (refby). can we use two AND operator in a query?

varuncodee 24-Feb-12 8:33am View

Thank you very much sir.

But this query is not giving me desire result when i select dateTimePickerstart as 2/7/2011 and dateTimePickerend as 2/8/2011 and it return all records between Feb 8 to Feb 9 without matching doctor name (refby). can we use two AND operator in a query?

Comments by varuncodee (Top 29 by date)