Comments by iamvinod34

iamvinod34 5-Jul-17 6:23am View

can you give me idea about interact SQL server using workflow and real time example. actually i know server side table like System.Activities.DurableInstancing.instanceTable.but i do't know how to mapping?

iamvinod34 16-Feb-16 6:21am View

images slider show

iamvinod34 15-Feb-16 20:52pm View

sorry .iam using database .sdf file
how? plz sorry

iamvinod34 24-Jan-16 22:20pm View

this datepart() function separate separate will shown only date or month
but i want date and year display one column only..? how?

iamvinod34 23-Jan-16 21:48pm View

plz read solition 2...
dave krekowiak do not access without install sql server answer told...
you no need to intall sql server answer told ....
which is correct?

iamvinod34 21-Jan-16 2:01am View

which events is fired ...
i do't know ...
plz help me

iamvinod34 20-Jan-16 23:47pm View

i do't know....without using buttons save data .....when user enter values automatically save data from database

iamvinod34 20-Jan-16 23:41pm View

when user enter values on datagridview automatically save data form database table

iamvinod34 20-Jan-16 23:40pm View

plz open this link....
http://www.c-sharpcorner.com/forums/how-to-display-excell-cursor-in-datagridview-c-sharp-win-app

iamvinod34 10-Jan-16 23:15pm View

windows application c#
datetimepicker.....
default value as zero....
...employee Leaving date...

iamvinod34 6-Jan-16 0:24am View

please send any link...
how to use sql compact tutorial

iamvinod34 30-Dec-15 10:56am View

sir,
how to write logic code?
i know 3tier ....but i want logical coding ..
thanks

iamvinod34 7-Nov-15 22:49pm View

my vs 2015..
entity framework6.1.3 is there in my vs 2015 but i want entity framework 5.0.0
because entity framework6.1.3 version not compatibility for vs 2015 ...
thq u ....
help me plz...
how to install entity framework 5.0.0?

iamvinod34 14-Jul-15 3:22am View

webforms...but i want bundleconfig.cs

iamvinod34 14-Jul-15 1:39am View

read my question sir...

iamvinod34 14-Jul-15 1:37am View

read my question sir...

iamvinod34 11-Jul-15 11:56am View

plz open this link you understanding
http://www.c-sharpcorner.com/Forums/Thread/308096/how-to-write-title-using-master-page-gt-child-web-form.aspx

iamvinod34 6-Jun-15 3:16am View

plz tell me one example plz
help me plz

iamvinod34 4-Jun-15 6:04am View

this is web form page sir...
url: "Default.aspx/MethodName"---> this syntax not executed sir
url: "Default/MethodName" ----> this syntax else part did executed sir
so plz help me sir...
3-days i tried this prlbm

iamvinod34 3-Jun-15 13:04pm View

ya...but no answer sir...

iamvinod34 2-Jun-15 22:55pm View

url:Bind.aspx/BindDataTable not fsire sir,,,no action
url:Bind/BindDataTable
error: function (result) {
alert("Error");
} this did executed sir

iamvinod34 2-Jun-15 14:23pm View

iam using Bind data to gridview with JQuery or JSON in asp.net

Form :<form id="form1" runat="server" action="Bind.aspx" method="post">
<asp:GridView ID="gvDetails" runat="server">
<HeaderStyle BackColor="#DC5807" Font-Bold="true" ForeColor="White" />

Jquery Ajax Code :<script type="text/javascript">
$(document).ready(function () {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Bind/BindDatatable",
data: "{}",
dataType: "json",
success: function (data) {
for (var i = 0; i < data.d.length; i++) {
$("#gvDetails").append("<tr><td>" + data.d[i].UserId + "</td><td>" + data.d[i].UserName + "</td><td>" + data.d[i].Location + "</td></tr>");
}
},
error: function (result) {
alert("Error");
}
});
});
</script>
Page_Load Event :
private void BindColumnToGridview()
{
DataTable dt = new DataTable();
dt.Columns.Add("UserId");
dt.Columns.Add("UserName");
dt.Columns.Add("Location");
dt.Rows.Add();
gvDetails.DataSource = dt;
gvDetails.DataBind();
gvDetails.Rows[0].Visible = false;
}
Web Method Code : [WebMethod]
public static UserDetails[] BindDatatable()
{
DataTable dt = new DataTable();
List<userdetails> details = new List<userdetails>();

using (SqlConnection con = new SqlConnection("Data Source=184.168.47.17;Initial Catalog=Question_Papers;User ID=Shravan;Password=Shravan@34; Trusted_Connection=False"))
{
using (SqlCommand cmd = new SqlCommand("select TOP 10 UserId,UserName,Location from Test_1", con))
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dtrow in dt.Rows)
{
UserDetails user = new UserDetails();
user.UserId = dtrow["UserId"].ToString();
user.UserName = dtrow["UserName"].ToString();
user.Location = dtrow["Location"].ToString();
details.Add(user);
}
}
}
return details.ToArray();
}
Class :
public class UserDetails
{
public string UserId { get; set; }
public string UserName { get; set; }
public string Location { get; set; }
}

code not executed....jquery ajax error did executed...this::::error: function (result) {
alert("Error");
}
so plz help me sir

iamvinod34 2-Jun-15 13:12pm View

for example:
<input type="text" name="Name" id="txtname" width="120" /> this html input control na..ok
this input control shown codebehind... how to write code in c#...in default.aspx.cs?

iamvinod34 2-Jun-15 13:09pm View

ok, but iam using webform pages
sir

iamvinod34 2-Jun-15 12:47pm View

html controls are not accessible in code behind asp.net c# code

iamvinod34 2-Jun-15 12:05pm View

bind is asp webform page name and Binddatatable webmethod name
--->url:bind.aspx/Binddatatable is current process but this not excuted
iam writing url:bind/Binddatatable ---->
error: function (result) {
alert("Error");
} excuted
sir
:)

iamvinod34 19-May-15 7:49am View

plz tell ans...this is interview question sir....

iamvinod34 8-Apr-15 13:15pm View

i want
how to write meta tags below link
http://localhost/website/Alldata?ID=23

Alldata--->all.aspx(rewriteing page)

iamvinod34 7-Apr-15 8:35am View

yes....

iamvinod34 7-Apr-15 6:29am View

How do you add meta tags that change depending on the browser's query string parameter?

For example, on my blog site the blogs are read from a database and a sample blog would be http://www.example.com/blog/blog.aspx?ID=32

how write meta tags above link
plz help

iamvinod34 19-Feb-15 12:09pm View

in data base's table should be display in grid view as 3 tier architecture ?
help me plz

iamvinod34 19-Feb-15 4:04am View

how to check username is available or not in asp.net using data access layer sir...?
how to pass data access layer to presentation layer?

iamvinod34 16-Feb-15 6:54am View

ok ,how to insert image every paragraph in css
help me sir

iamvinod34 16-Feb-15 6:54am View

ok ,how to insert image every paragraph in css
help me sir

iamvinod34 16-Feb-15 6:53am View

ok ,how to insert image every paragraph in css
help me sir

iamvinod34 16-Feb-15 6:53am View

ok ,how to insert image every paragraph in css
help me sir

iamvinod34 16-Feb-15 6:51am View

yes sir

iamvinod34 21-Jan-15 1:20am View

name,id,image...ect sir....

iamvinod34 20-Jan-15 23:04pm View

how to pass facebook parameter values in one page to another page and send to database?
iam try using sessions but result not showing sir
plz help me.....

iamvinod34 19-Jan-15 23:56pm View

i want to insert text and image sequentially in cell ...it should be show in gridview .plz tell code
For Example : mathematical equations and formulas
plz help me

iamvinod34 19-Jan-15 4:04am View

thank sir

iamvinod34 19-Jan-15 1:27am View

plz help me sir

iamvinod34 18-Jan-15 12:28pm View

i do't know sir,
how to Authentication facebook and google+?
plz help me...........
i want user logined after redirect to Log_in.aspx
plz help me sir

iamvinod34 17-Jan-15 13:45pm View

yes..

iamvinod34 17-Jan-15 13:33pm View

no sir,
Ms access

iamvinod34 16-Jan-15 22:30pm View

My code and your code both are same sir ?

iamvinod34 15-Jan-15 7:03am View

right sir... k ..thank u sir....solution plz

iamvinod34 13-Jan-15 12:43pm View

i do't know how to write.....but understanding
for example:string s="select * from emp"+"select * form dept";
both table display on gird view
help me plz

iamvinod34 27-Dec-14 22:27pm View

plz tell me the full details plz....

iamvinod34 27-Dec-14 12:35pm View

i am data entry ms access

iamvinod34 25-Dec-14 2:04am View

no...plz read again
plz help me

iamvinod34 22-Dec-14 9:52am View

any equation i want

iamvinod34 22-Dec-14 3:33am View

If (x-2)/(x-1)≥1,∈,∞, |-2+(x+3)/(x+1)|=(x-1)/(x+1),f(x)=√(2-x),y=√(1-x^2 )
f(x)={█(x+2 ,
x<-1@x^2,
-1≤x<1@2-x,
x≥1)┤

iamvinod34 20-Dec-14 6:57am View

try
{
string[] validFileTypes={"bmp","gif","png","jpg","jpeg","JPG","BMP","GIF","PNG","JPEG"};
string ext = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName);
bool isValidFile = false;
for (int i = 0; i < validFileTypes.Length; i++)
{
if (ext == "." + validFileTypes[i] )
{
isValidFile = true;
break;
}
}
if (!isValidFile)
{
Response.Write("<script language='javascript'>alert('Invailed File')</script>");
}

else if(FileUpload1.PostedFile.ContentLength<40000)
{
string s = "select * from " + U_name.Text + "where EXISTS(select * from "+U_name.Text+"Image=@Image";
SqlConnection conimage = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
SqlCommand cmdimage = new SqlCommand(s, conimage);
Byte[] bytes = null;
if (FileUpload1.HasFile)
{
string filename = FileUpload1.PostedFile.FileName;
string filePath = Path.GetFileName(filename);
Stream fs = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
bytes = br.ReadBytes((Int32)fs.Length);
}
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
SqlCommand command = new SqlCommand("UPDATE " + U_name.Text + " SET Image=@Image " + "", con);
command.Parameters.Add("@Image", SqlDbType.Binary).Value = bytes;
con.Open();
command.ExecuteNonQuery();
Label2.ForeColor = System.Drawing.Color.Green;
Label2.Text = "UPDATE Successfully";
}
else
{
Response.Write("<script language='javascript'>alert('Maximum 4MB Allowed')</script>");
}

if(FileUpload1.PostedFile.ContentLength<40000)
{
Byte[] bytes = null;
if (FileUpload1.HasFile)
{

string filename = FileUpload1.PostedFile.FileName;
string filePath = Path.GetFileName(filename);
Stream fs = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
bytes = br.ReadBytes((Int32)fs.Length);

}
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
SqlCommand command = new SqlCommand(
"INSERT INTO " + U_name.Text + " (U_name, Image) " +
"Values(@U_name, @Image)", con);
command.Parameters.Add("@U_name",
SqlDbType.NVarChar, 20).Value = U_name.Text.Trim();
command.Parameters.Add("@Image",
SqlDbType.Binary).Value = bytes;
con.Open();
command.ExecuteNonQuery();
Label2.ForeColor = System.Drawing.Color.Green;
Label2.Text = "Successfully";
}
else
{
Response.Write("<script language='javascript'>alert('Maximum 4MB Allowed')</script>");
}
}
catch (Exception ex)
{
throw new Exception("Error" + ex.Message);
}
this my file upload button click event

i want user first time upload insert command.
user second time upload update command executed.
two commands only one button tell me
plz help me

iamvinod34 20-Dec-14 6:34am View

how to check image data available or not
plz help me

iamvinod34 20-Dec-14 4:08am View

else if(Image2.ImageUrl==null)------>UPDATE SUCCESSFULY IS CAME
else if(Image2.ImageUrl!=NULL)------>INSERT SUCCESSFULLY
but i want user first time upload insert command.
user second time upload update command executed.
two commands only one button tell me
plz help me

iamvinod34 20-Dec-14 0:41am View

For registered user we can use update panel . but for new user we can not update we will use insert na?

iamvinod34 20-Dec-14 0:29am View

Deleted

In that Image column how can i find old image row For update command

iamvinod34 19-Dec-14 0:51am View

no....how to write code for routing?
for example:home
localhost/vinod/index.aspx came
but i want localhost/vinod/home ...how to write code?

iamvinod34 18-Dec-14 11:29am View

yes,single tables into groups
plz tell . sql query and user click on button create table with groups divide
plz help sir

iamvinod34 18-Dec-14 10:02am View

Deleted

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABVAAAAJwCAIAAADgF92nAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAHQKSURBVHhe7d2xjmVLm9Z5LmSsEdLcA864I9RCXEWbGEiNO1eAhIngErDawWm1cNvoG0CIdpDaGwPaQEhI31Rl/J+olZF778wVVbVixXv+P4Ux58lVmbnjXfF+8dY59PyjP0mSJEmSpHIc+CVJkiRJKsiBX5IkSZKkghz4JUmSJEkqyIFfkiRJkqSCHPglSZIkSSrIgV+SJEmSpIIc+CVJkiRJKsiBX5IkSZKkghz4JUmSJEkqyIFfkiRJkqSCHPglSZIkSSrIgV+SJEmSpIIc+CVJkiRJKsiBX5IkSZKkghz4JUmSJEkqyIFfkiRJkqSCHPglSZIkSSrIgV+SJEmSpIIc+CVJkiRJKsiBX5IkSZKkghz4JUmSJEkqyIFfkiRJkqSCHPglSZIkSSrIgV+SJEmSpIIc+CVJkiRJKsiBX5IkSZKkghz4JUmSJEkqyIFfkiRJkqSCHPglSZIkSSrIgV/S7/X//R//2HXNYsclSZKkNw78kn6vYSh1/b7FjkuSJElvHPgl/V7DUOr6fYsdlyRJkt448Ev6vRxHfzd3WJIkSQ858Gsz//HP/9F3/+Tf/BeCV/7Lv/knb0//+X8k0DPZqi/u7BnXjaOnXo6T7vziXbfDkiRJ2ooDv36LPj5+5vRE5MD/ezjwf8KBX5IkSdtx4Nc1ftko5sC/nevG0YcvB+HPvgQO/JIkSdqOA7+u4cD/x3XdOOrAL0mSJB048OsaDvx/XNeNow78kiRJ0oED/x/Gf/33//3bSPBP//3/5p8v9oVxKYPZwYPHf3yjDFXdx+nqxdz14U9/dTh7/gs8+XBf+lyH33R4Pr/W8NOe/bbTn+vwG7wz/vpPPuUL78bRj79f9+M7//hd3v309z/6wS9GxHPPf9T7zzh+o28efMgf3/vD9/24w88285uPv9UXC/TCux2WJEmSovbA/9f/kHvwYf2r/8VXf5E2SI/rn//P/8rX7+LWA39GrsPo06ewYRx6P53l+yUdvv+TuavPXMmf/bBHHv4CT75B4kP65Mn3Y2D7rj9+zT9/933yLT5s5k99rkd7lSw/iX/+/Lu9+8H9XIy/ef99x0/Sv/Dmw+f8+MH6P795/wfytUe/9YOvjd86Hv+IpMPv+Ggzv+mfK/mzH3bSjx2WJEmSDv4IA/9vnr0Z+H/13yP8cvf/N/yjTEePx7dv3g1JD59+OHflO7yfsR6nD/z4BR7+qM8/4cvf9JtDfkjfPf5wN3/ycz3Yq4c/5it+/N7f/2wfRx/8Ko9/vce70T38Q0//zJd3IPKdHn+bbx7+3HdPJ3z35ONf5PSv90DfYf5ZkiRJeuPA/9Mc+L+EsebR+PbUy6np43d6MDk9+A6Pp7lvHv60B54NaF/984+ffPJrJR6/68ftfPINvv57fXzu6bf8XDbp7bv1cfTBL/L4ZyR9/Ft//PDIT33/lWcFe+7hlj3+5t89+AEPvsPT3Xz4087pO8w/S5IkSW/+4AP/3/3Pf8pFmfUv/5qvfMMk/2P993/7d3zp6MXAz5d+/AL/+9/+8+/fqk/df/Wvjt//3TQ+fOlt/cNf5Tu09fH5f/rP3/3OxwceDPzD/5OH3/p3Fk+HtBcejkgvvtHHLz2YpZ7/+Qdz2yNPv8GL3+y9R5/r2Tj45Jt+/F2f//SPzz70fK++8JFe6u/Yo2/28Pd+thtvnn/Sx1/64uc/ePjjT/3Y55v54M+f/wVHfYf5Z0mSJOnNH3ngZ9zNGJ/hv4/EPwb+l/+NwIuBv0/47e8RmOF58t2X/vSn//Uv335W/xuHHwP/2/PH+f/tmefP89vywPBxPny6f/ir7/+Uv0f4fTP/i3Hpqcm56zA4fZy7Hkxi8eJLR09/gS9/xEef6+Fn/ebJN/3wUX/+cz18LD/nm88/1zN5M9vA//4HPP7cz3bju1dfe7hbH/bqUw9/xJNKfPfxJ3zczI9J9+JLX9R3mH+WJEmS3vzx/o/2ZeIdB+bveL7NwMNI/NSPvxf4sQ7/LcDwHxE8/7uD4S8O3v/twI/v03/hT57/5v3fd7Tn33/843+z0JJPPuy8F+NSl7lp9NW56ytT1rOfcfDJ3PX0F/jsCx8cn8xvOv7pJ98037L/rs9+xsEnn+vp2JkvNB8/3qfe3szva/yln37sZ7vx3dPf85uHu/Vhrz54tnnvvs/D7918/JU+Jj9foBf6DvPPkiRJ0ps/7L/hZ34e5tt3Y/AwUT/z6WOHfzn/+P9RQPNwgO//Qv7BQN4+3dPnv3nwcXigffx3OzP8Fwe/2otx6bs+Dh0feDj2vfhG+Sav5q5X4+LXPP0FHn3hy5/r4Wf95slP+/BRf/5zffYd8vVvTv6Q7+/V2xp3o//z+A2f7cZ3r772cLc+7NXR+Cu9efgjHn7v5uNP+LiZH5NfqO8w/yxJkiS9+cMO/I+/9G7o/VUDfwbvYRr/7vB3AVnXDPztzz5aSwb+JyPZybnrweO/Y+56+gt8/MKJz/Xws37z5Kd9+M4//7m+8h2e/Zav9bfr7c+OHv28lz/naQGefOlJFb578qWHP/75j33w+MfN/Jj8Qn2H+WdJkiTpjf+Gn39uHkzIPz/wH6f6wzg9/i3A8H1+3cDPH3k38D/4N/y/2Ysp7eks9GruevCdHvyIB9/5pwevp5/kwxfOfK6Hn/WbJz8tu/DjW//05/rSN/j4c7/g+5v5tr78R5/txpvnX8xv9/4rz3/nZx/54U94/M2/4yvHLzz4zs9+2K/Qd5h/liRJkt78cf+P9r2b7fH++V8z8Pfv2f4/+sT+YeT+JQP/u1/j0cfJN/zw3X63B0PRD4+/mAnr8dz1zbvR6eGQ9nDIevmrfO7pH//4hceP9k9wzB/++t88+Wn5HscP9uTRr/rKQPrst/ygf8bv3+3tzfy+fkSf+OTnPPr0/c988/6Pvfhgj7es//Lv8p4++bnvHn74Mx//tF+h7zD/LEmSJL354w78GbCHCfz5/1W8Z14+9u6vFXiS36d96f3/84HD95kc+L+t9v2ffJz+Dd//Ms/+k4df5/Ww04epDEiH6er53PUNX+rD3jDUPZn1Pvy4717/hj88fe7BFz78oB58d3zy4dj4zZOflu/z/oN9+HHfPfkOH3zYq6fBp9+qP9mezZv5j3/Eg/E7fvqT8knzQP/kb4Y/9uK7fdixd9/o3R94+CP6J3pfiJ4P8Ycf9x3hg9/uy/oO88+SJEnSmz/wwP9de+DHevcv/F9O8j/8mNXfre+T88d/6/4uyUz+bv38wH9Yx/8H+cPA/9348X/btP/Np1PN02Hw8dz1bWJ6P4F9GK6+ezJ3fffo531p5nr6SR5/4YufK4+N3/bJT8tn//jBpj/Xo7168M0ebOUDvTbfH+8v2KOP2H/EV3bjaPzdvj9L9vGP9d/nzbuvP/iM8e45vsW3D/T+mz3cknzTF186evU5v6LvMP8sSZIkvak98P+RfPgLAukm+jj6ZLZ9/rcX+pq+w/yzJEmS9MaBvwoHft1VH0cfz/uv/nW4vqTvMP8sSZIkvXHgr8KBX3fVx9HHU33m/Z/979r/wPoO88+SJEnSGwd+Sb9XH0ff5vr3M3//fw/vuP8T+g7zz5IkSdIbB35Jv9dhHB3/7929cdb/WYcdliRJkn5w4Jf0e/Vx1PW7FzsuSZIkvXHgl/R7DUOp6/ctdlySJEl648Av6fcahlLX71vsuCRJkvTGgV+SJEmSpIIc+CVJkiRJKsiBX5IkSZKkghz4JUlPtf/rAP/3//O3LpfLtdHi/8evkirijqKvuWK/qMyd/On//b9cLpfL9cU13KRdLpfr5osLn6SKGDL1NQ78LpfL5fpkDTdpl8vluvniwiepIoZMfY0Dv8vlcrk+WcNN2u

iamvinod34 18-Dec-14 10:00am View

i have table :ID,Number,Name,Details is there
ID is one group
number and name is 2nd group
details is 3rd group in one table only

iamvinod34 18-Dec-14 9:50am View

plz click on this link :http://www.c-sharpcorner.com/Forums/Thread/279119/
picture is there

iamvinod34 18-Dec-14 6:54am View

what?

iamvinod34 18-Dec-14 6:24am View

My site name is:http:www.onlineexamsworld.com
after login into my web site i am getting folder names instead of URL .it for security purpose
help me plz

iamvinod34 18-Dec-14 6:24am View

My site name is:http:www.onlineexamsworld.com
after login into my web site i am getting folder names instead of URL .it for security purpose
help me plz

iamvinod34 18-Dec-14 4:25am View

this is query
con.Open();
string s = "select * from " + U_name.Text + " where Physics_Topic= '" + grdTopicname.Text + "'";
SqlCommand cmd = new SqlCommand(s, con);
cmd.Connection = con;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
string s1 = "UPDATE " + U_name.Text + " SET ID_Physics=@ID_Physics,Physics_Topic=@Physics_Topic,Physics_score=@Physics_score";
SqlCommand cmd1 = new SqlCommand(s1, con);
cmd1.CommandTimeout = 0;
cmd1.Parameters.AddWithValue("@ID_Physics", grdID.Text);
cmd1.Parameters.AddWithValue("@Physics_Topic", grdTopicname.Text);
cmd1.Parameters.AddWithValue("@Physics_score", Result.Text);
try
{

cmd1.ExecuteNonQuery();

}
catch (Exception ex)
{
throw new Exception("Error" + ex.Message);

}
}
else
{

}
string s2 = "insert into " + U_name.Text + "(ID_Physics,Physics_Topic,Physics_score)values('" + grdID.Text + "','" + grdTopicname.Text + "','" + Result.Text + "')";
SqlCommand cmd2 = new SqlCommand(s2, con);
cmd2.ExecuteNonQuery();
con.Close();

iamvinod34 18-Dec-14 4:17am View

normal query
20sec after error came

iamvinod34 18-Dec-14 1:52am View

error came sir,
Incorrect syntax near ')'.
Line 298: con.Close();
Line 299: }
Line 300: }------>error
Line 301: public string connectionString { get; set; }
Line 302:}

iamvinod34 18-Dec-14 1:47am View

Incorrect syntax near ')'.
Line 298: con.Close();
Line 299: }
Line 300: }------>error
Line 301: public string connectionString { get; set; }
Line 302:}

iamvinod34 18-Dec-14 0:08am View

no sir
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
string s = "select * from " + U_name.Text + " where Physics_Topic='" + grdTopicname.Text + "'";

SqlCommand cmd = new SqlCommand(s, con);
cmd.Connection = con;

using (SqlDataReader dr = cmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
dr.Read();
string s1 = "update " + U_name.Text + " set TopicID='" + grdID.Text + "',Physics_Topic='" + grdTopicname.Text + "',Physics_score='" + Result.Text + "'";
cmd.ExecuteNonQuery();

}
else
{
string s2 = "insert into" + U_name.Text + "where TopicID='" + grdID.Text + "',Physics_Topic='" + grdTopicname.Text + "',Physics_score='" + Result.Text + "'";
cmd.ExecuteNonQuery();
con.Close();
}
}

}
The ConnectionString property has not been initialized.
Line 266: using (SqlConnection con = new SqlConnection(connectionString))
Line 267: {
Line 268: con.Open();
Line 269: string s = "select * from " + U_name.Text + " where Physics_Topic='" + grdTopicname.Text + "'";
Line 270:

iamvinod34 18-Dec-14 0:07am View

Deleted

no sir
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
string s = "select * from " + U_name.Text + " where Physics_Topic='" + grdTopicname.Text + "'";

SqlCommand cmd = new SqlCommand(s, con);
cmd.Connection = con;

using (SqlDataReader dr = cmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
dr.Read();
string s1 = "update " + U_name.Text + " set TopicID='" + grdID.Text + "',Physics_Topic='" + grdTopicname.Text + "',Physics_score='" + Result.Text + "'";
cmd.ExecuteNonQuery();

}
else
{
string s2 = "insert into" + U_name.Text + "where TopicID='" + grdID.Text + "',Physics_Topic='" + grdTopicname.Text + "',Physics_score='" + Result.Text + "'";
cmd.ExecuteNonQuery();
con.Close();
}
}

}
The ConnectionString property has not been initialized.
Line 266: using (SqlConnection con = new SqlConnection(connectionString))
Line 267: {
Line 268: con.Open();
Line 269: string s = "select * from " + U_name.Text + " where Physics_Topic='" + grdTopicname.Text + "'";
Line 270:

iamvinod34 17-Dec-14 23:57pm View

yes sir
my code :
{

string s = "select * from " + U_name.Text + " where Physics_Topic='" + grdTopicname.Text + "'";
con.Open();
SqlCommand cmd = new SqlCommand(s, con);
cmd.Connection = con;

using (SqlDataReader dr = cmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
dr.Read();
string s1 = "update " + U_name.Text + " set TopicID='" + grdID.Text + "',Physics_Topic='" + grdTopicname.Text + "',Physics_score='" + Result.Text + "'";
cmd.ExecuteNonQuery();

}
else
{
string s2 = "insert into" + U_name.Text + "where TopicID='" + grdID.Text + "',Physics_Topic='" + grdTopicname.Text + "',Physics_score='" + Result.Text + "'";
cmd.ExecuteNonQuery();
con.Close();
}
}

}

iamvinod34 17-Dec-14 23:54pm View

Deleted

yes sir
my code is:
using (SqlConnection con = new SqlConnection(connectionString))
{

string s = "select * from " + U_name.Text + " where Physics_Topic='" + grdTopicname.Text + "'";
SqlCommand cmd = new SqlCommand(s, con);
cmd.Connection = con;

using (SqlDataReader dr = cmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
dr.Read();
string s1 = "update " + U_name.Text + " set TopicID='" + grdID.Text + "',Physics_Topic='" + grdTopicname.Text + "',Physics_score='" + Result.Text + "'";
cmd.ExecuteNonQuery();

}
else
{
string s2 = "insert into" + U_name.Text + "where TopicID='" + grdID.Text + "',Physics_Topic='" + grdTopicname.Text + "',Physics_score='" + Result.Text + "'";
cmd.ExecuteNonQuery();
con.Close();
}
}

}

iamvinod34 17-Dec-14 23:41pm View

The ConnectionString property has not been initialized.
con.open();

iamvinod34 17-Dec-14 23:32pm View

SqlDataReader dr = cmd.ExecuteReader(); get eror

iamvinod34 17-Dec-14 10:59am View

sir how to display selected row on label?

iamvinod34 24-Nov-14 3:50am View

form authentication

iamvinod34 23-Nov-14 21:57pm View

iam developing online examination....

iam junior
this year passout
plz helo me

iamvinod34 23-Nov-14 21:53pm View

Web forms and asp.net folders and web.config

iamvinod34 23-Nov-14 4:58am View

but
who is user loged can not access after login page?

Comments by iamvinod34 (Top 81 by date)