Click here to Skip to main content
14,740,518 members

Comments by Sumit_Kumar_Sinha (Top 62 by date)

Sumit_Kumar_Sinha 16-Mar-15 3:29am View
   
Suppose, i have a query and it's taking aroung 70 second to complete a transaction but inmean while other users reqeusted 10-15 request to complete transaction on same table. After 70 sec, all other transction executed succesfully but i got 3-4 deadlock error.
Sumit_Kumar_Sinha 16-Mar-15 3:14am View
   
For Example, I have a table Test. It contains all the information realted to each and every transaction. This table is used by all the employee. Suppose, when i am trying to fetch records from this table and same time some other transaction (Insert, update or delte) is in pogress. Then nolock will not provide exact records from this table. Thats why i am looking for some other way to select records. I have already used nowait, setlocktimeout, nolock, readcommited but it's not giving me correct details.
Sumit_Kumar_Sinha 16-Mar-15 2:42am View
   
It's not interview question. I am trying to fix this issue in my application
Sumit_Kumar_Sinha 15-Mar-13 9:00am View
   
you can use remov dash(-) and then simply compare the value of textbox1 and textbox2
Sumit_Kumar_Sinha 15-Mar-13 8:54am View
   
you are maintaing viewstate for asp.net control, and what is meaning of different events.
Sumit_Kumar_Sinha 14-Mar-13 9:43am View
   
you are using asp.net textbox control or html
Sumit_Kumar_Sinha 14-Mar-13 9:11am View
   
i m not getting
Sumit_Kumar_Sinha 14-Mar-13 7:11am View
   
can u post ur script....................
Sumit_Kumar_Sinha 14-Mar-13 6:42am View
   
simply u can store all textbox values in session and at the time of inserting the record u can use session value ..............
Sumit_Kumar_Sinha 14-Mar-13 6:39am View
   
you can check ur css and test on IE.....................if in IE it's good............then in every browser it will good........................many time i also face this type of problem...
Sumit_Kumar_Sinha 14-Mar-13 6:33am View
   
post asp.net script for question
Sumit_Kumar_Sinha 18-Feb-13 3:55am View
   
For this you can use Ajax Toolkit Control Filtered Textbox
Sumit_Kumar_Sinha 14-Feb-13 6:13am View
   
you can use asp.net chart control(in data control) and bind it to the database.
Sumit_Kumar_Sinha 29-Jan-13 2:44am View
   
My problem is not sending the mail...........i want to send the mail in same asp.net design format, which is filled by the user.
Sumit_Kumar_Sinha 28-Jan-13 4:23am View
   
You can use Ajax Toolkit control Password Strength.............
Sumit_Kumar_Sinha 21-Jan-13 2:42am View
   
any other way to fetch Unique CouponsID and title
Sumit_Kumar_Sinha 21-Jan-13 2:14am View
   
the above is output........i want to select the distinct reocrds because "KRIAA - Men's Handloom Embroidery Short Kurti ( TTMK 4011 )" title repeated two times in the output
Sumit_Kumar_Sinha 21-Jan-13 2:13am View
   
16 KRIAA - Men's Handloom Embroidery Short Kurti ( TTMK 4011 )
17 KRIAA - Men's Handloom Embroidery Short Kurti ( TTMK 4011 )
39 Crosscreek Fil-A-Fil Casual Shirt
46 Live Life Colorful : Western Wear.....
47 50% Off For Select Time Period
Sumit_Kumar_Sinha 21-Jan-13 2:12am View
   
with CTE as
(
select CouponsStock.CouponsID, ProdSubCatItemsDescription.Items_Desc_ShortDescription,
ROW_NUMBER() over(PARTITION BY CouponsStock.CouponsID, ProdSubCatItemsDescription.Items_Desc_ShortDescription order by ProdSubCatItemsDescription.Items_Desc_ShortDescription )as Cnt
from category inner join ProductCategory on
category.Cat_ID=ProductCategory.Cat_ID
inner join ProductSubCategory on ProductCategory.Prod_Cat_ID=ProductSubCategory.Prod_Cat_ID
inner join ProductSubCatItmes on ProductSubCategory.Prod_Sub_Cat_ID=ProductSubCatItmes.Prod_Sub_Cat_ID
inner join ProdSubCatItemsDescription on ProductSubCatItmes.Prod_Sub_Cat_Items_ID=ProdSubCatItemsDescription.Prod_Sub_Cat_Items_ID
inner join CouponsStock on ProdSubCatItemsDescription.Prod_Sub_Cat_Items_Desc_ID=CouponsStock.Prod_Sub_Cat_Items_Desc_ID
where category.Cat_Name='Fashion'
and ProdSubCatItemsDescription.Items_Desc_Status<>'Disabled'
and CouponsStock.CouponsEndDate>=GETDATE()
and CouponsStock.CouponsStatus='Visible'
)
select CouponsID, Items_Desc_ShortDescription
from CTE where Cnt=1
Sumit_Kumar_Sinha 18-Jan-13 1:51am View
   
Deleted
..
Sumit_Kumar_Sinha 18-Jan-13 1:16am View
   
You use dropdownlist OnIndexChanging then clear controls values...
Sumit_Kumar_Sinha 18-Jan-13 1:07am View
   
public void LoadGridData() // Bind GridView Data
{
SqlCommand cmd = new SqlCommand("select * from Emp_tabl1 ", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

}
Sumit_Kumar_Sinha 18-Jan-13 1:02am View
   
actually i am not working on winform...............if u need code for web form then i will provide you................you can make changes according to your requirement
Sumit_Kumar_Sinha 18-Jan-13 0:59am View
   
Hey.............In asp.net many datacontrols are avaliable for display data...you can use ..............
Sumit_Kumar_Sinha 18-Jan-13 0:57am View
   
Hey...........You want to fetch the data from database and Display in Winform........or You want to insert winform data in database..............because above code you wrote for data insertation...
Sumit_Kumar_Sinha 18-Jan-13 0:53am View
   
If ID in auto increment then..........we are not mentioning ID at the time of data insertation
Sumit_Kumar_Sinha 18-Jan-13 0:51am View
   
Instead of asp:BoundField you use a <asp:TemplateField>............i think when we are using <asp:BoundField> then it's by default create with textbox.................the best way for using gridview you can use <asp:TemplateField>..............
Sumit_Kumar_Sinha 18-Jan-13 0:30am View
   
post the complete design of girdview
Sumit_Kumar_Sinha 17-Jan-13 0:16am View
   
same error is coming....................
Sumit_Kumar_Sinha 17-Jan-13 0:15am View
   
for distinct city PID and Name
Sumit_Kumar_Sinha 16-Jan-13 1:25am View
   
it's throwing error :- Invalid column name 'City'.
Sumit_Kumar_Sinha 15-Jan-13 9:34am View
   
i need city and pid in the final result
Sumit_Kumar_Sinha 15-Jan-13 6:36am View
   
hey....i want to select city name and last Inserted PID for each city ........
Sumit_Kumar_Sinha 12-Dec-12 0:35am View
   
at least first understand the question then reply.........................
Sumit_Kumar_Sinha 11-Dec-12 8:05am View
   
no.............i have two in first div i have a datalist here i m displaying the image.....in second div i have another datalist.....i want to when use cliked on first datalist image it's display complete information in second datalist...........
Sumit_Kumar_Sinha 10-Dec-12 5:52am View
   
i want to design like , http://in.yahoo.com/?s=https, see body center top image.....
Sumit_Kumar_Sinha 6-Dec-12 6:28am View
   
TotalQty int (in database)...........but data inserting time i m not putting the Qty value...........so i want to put null in database if qty textbox is empty
Sumit_Kumar_Sinha 6-Dec-12 1:48am View
   
using PostBackURL
Sumit_Kumar_Sinha 6-Dec-12 1:42am View
   
any other way to solve this one............
Sumit_Kumar_Sinha 6-Dec-12 1:39am View
   
but in stored procedure i define the all fileds.........it creates any problem....
Sumit_Kumar_Sinha 6-Dec-12 1:29am View
   
first time use upload thier image.....but second they not want to change the image...only they want to chagne other fileds...........
Sumit_Kumar_Sinha 15-Nov-12 2:17am View
   
Hey....above code is not working...........please guide me.........i m not getting...how can i solve this.
Sumit_Kumar_Sinha 9-Nov-12 1:57am View
   
It's throwing some error like :-

Compiler Error Message: CS0103: The name 'xml' does not exist in the current context

Source Error:


Line 19: HttpWebRequest webRequest = null;
Line 20: string response = "";
Line 21: byte[] bytes = Encoding.UTF8.GetBytes(xml);
Line 22:
Line 23: try
Sumit_Kumar_Sinha 7-Nov-12 4:28am View
   
nothing
Sumit_Kumar_Sinha 7-Nov-12 0:42am View
   
I crated a web form for sedning sms with all required field.....but i have confusion, how can i send below url afer clicking on Send button.
http://api.fastalerts.in/fastclient/SMSclient.php?username=senderusername&password=senderpwd&message=msg&numbers=phonenumber&senderid=senderid
Sumit_Kumar_Sinha 6-Nov-12 0:36am View
   
explain the problem properly.......
Sumit_Kumar_Sinha 26-Oct-12 2:54am View
   
my requirement is something different.....second last in the id is showing the current date and last one is customer id of that date....for next date second last date is change and last one again start from 0001
Sumit_Kumar_Sinha 22-Oct-12 2:08am View
   
can explain scenario of dropdown.................
Sumit_Kumar_Sinha 22-Oct-12 1:58am View
   
remove the VWD 2010 and again install it...............
Sumit_Kumar_Sinha 19-Oct-12 8:13am View
   
can u explain question properly..........not post a half part of question.....
Sumit_Kumar_Sinha 19-Oct-12 8:11am View
   
can u explain your problem clearly........properly i am not getting....
Sumit_Kumar_Sinha 19-Oct-12 8:10am View
   
microsoft sql server 2008 express edition
Sumit_Kumar_Sinha 19-Oct-12 7:57am View
   
yeah...........
Sumit_Kumar_Sinha 19-Oct-12 7:51am View
   
there are many online code converter available for vb to c#.....u can covert it easily
Sumit_Kumar_Sinha 19-Oct-12 6:31am View
   
can u explain question.............clearly i m not getting.
Sumit_Kumar_Sinha 17-Oct-12 7:28am View
   
Rajasekhar, can u explain your problem.....................
Sumit_Kumar_Sinha 17-Oct-12 6:31am View
   
Can u explain question clearly....
Sumit_Kumar_Sinha 17-Oct-12 6:22am View
   
Mukesh_Chauhan, according you i developed the all the table...but now problem is that, suppose we use the 20 menu for admin panel and i want to for manger it's display only 15 menu.....and different employee for different so on.........how we can do it
Sumit_Kumar_Sinha 17-Oct-12 2:29am View
   
I am working as a software engineer........i am not running a organisation...then it's possible to get subscription id
Sumit_Kumar_Sinha 16-Oct-12 3:30am View
   
The best way to uploading the image is that you can store image in solution explorer's and save image path in database.......
Sumit_Kumar_Sinha 15-Oct-12 5:55am View
   
Update your vs 2008 to sp1............then again add ajax toolkit control.........few months back i faced this issue and i updated my vs and now it's working fine.
Sumit_Kumar_Sinha 15-Oct-12 2:23am View
   
we can upload image in database not load..........