Click here to Skip to main content
13,702,739 members

Comments by Raj.Rautela (Top 86 by date)

Raj.Rautela 22-Apr-16 4:52am View
   
Apppool name is same as appname with framework ver 4.0 and mode is classic
Raj.Rautela 8-Mar-13 2:04am View
   
i am displaying data inside listview with image for eg "person's image and details" than what i should do to send image also to email..i'hv saved image in a folder and image-path in database and dynamically binding image-path in listview to display image.and i want to send the ssame image with details to email..what should i do..
Raj.Rautela 8-Mar-13 1:47am View
   
what changes i should make to display image properly in email..
Raj.Rautela 23-Jan-13 2:52am View
   
thanks for the help...sir
Raj.Rautela 23-Jan-13 2:51am View
   
thanks for the help...sir
Raj.Rautela 23-Jan-13 2:48am View
   
thanks sir i took nvarchar(max) and data is inserted properly..thanks a lot..
Raj.Rautela 23-Jan-13 2:20am View
   
sir tried your suggestion.. string moonraashi = ddlmoonraashi.SelectedItem.Text; string maanglik = rbtnlmaanglik.SelectedItem.Text; cmdins.Parameters.AddWithValue("@Moon_Rashi", moonraashi); cmdins.Parameters.AddWithValue("@Manglik", maanglik); Object reference not set to an instance of an object. here is the error but m not able to solve pls help...
Raj.Rautela 23-Jan-13 2:20am View
   
sir tried your suggestion..

string moonraashi = ddlmoonraashi.SelectedItem.Text;
string maanglik = rbtnlmaanglik.SelectedItem.Text;


cmdins.Parameters.AddWithValue("@Moon_Rashi", moonraashi);
cmdins.Parameters.AddWithValue("@Manglik", maanglik);

Object reference not set to an instance of an object.


here is the error but m not able to solve pls help...
Raj.Rautela 23-Jan-13 1:17am View
   
sir I manually passed all the parameters and data was inserted properly..
Raj.Rautela 23-Jan-13 1:16am View
   
y it is not inserting values from controls on the page..
Raj.Rautela 23-Jan-13 1:14am View
   
sir i passed parameters manually in storeproc data was inserted properly..
cmdins.Parameters.AddWithValue("@Profile_Name", "asdfg");
cmdins.Parameters.AddWithValue("@Gender","Male");
cmdins.Parameters.AddWithValue("@First_Name", "sadsad");
cmdins.Parameters.AddWithValue("@Last_Name", "sfsdf");
cmdins.Parameters.AddWithValue("@Email", "sdafsds");
cmdins.Parameters.AddWithValue("@Password", "dfsdfsdf");
cmdins.Parameters.AddWithValue("@Mobile_No", "9865");
cmdins.Parameters.AddWithValue("@Region", "dsdvsdv");
cmdins.Parameters.AddWithValue("@Caste", "vvsdvsv");
cmdins.Parameters.AddWithValue("@DOB","1-jan-1988");
cmdins.Parameters.AddWithValue("@Age", 24);
cmdins.Parameters.AddWithValue("@Mother_Tounge", "hindi");
cmdins.Parameters.AddWithValue("@Edu_Id", 1);
cmdins.Parameters.AddWithValue("@Occ_Id", 1);
cmdins.Parameters.AddWithValue("@Height", 5.8);
cmdins.Parameters.AddWithValue("@Weight",62);
cmdins.Parameters.AddWithValue("@Country_Id",3);
cmdins.Parameters.AddWithValue("@State_Id", 4);
cmdins.Parameters.AddWithValue("@City_Id",3);
cmdins.Parameters.AddWithValue("@Income", 50000);
cmdins.Parameters.AddWithValue("@Body_Type", "fit");
cmdins.Parameters.AddWithValue("@Complexion", "Fair");
cmdins.Parameters.AddWithValue("@Maritial_Status", "Married");
cmdins.Parameters.AddWithValue("@Religion", "Hindu");
cmdins.Parameters.AddWithValue("@Address", "Abcd");
cmdins.Parameters.AddWithValue("@Pincode", "12345");
cmdins.Parameters.AddWithValue("@About_Me", "dsfsf");
cmdins.Parameters.AddWithValue("@About_Match", "gfdg");
cmdins.Parameters.AddWithValue("@About_Family", "dsfsf");
cmdins.Parameters.AddWithValue("@Father", "Yes");
cmdins.Parameters.AddWithValue("@Mother", "Yes");
cmdins.Parameters.AddWithValue("@No_Of_Bro", 1);
cmdins.Parameters.AddWithValue("@No_of_Married_Bro", 1);
cmdins.Parameters.AddWithValue("@No_Of_Sis", 1);
cmdins.Parameters.AddWithValue("@No_of_Married_Sis", 1);
cmdins.Parameters.AddWithValue("@Place_of_birth", "dfsdfdsf");
cmdins.Parameters.AddWithValue("@Time_of_birth", "12.15");
cmdins.Parameters.AddWithValue("@Moon_Rashi", "bdcdsf");
cmdins.Parameters.AddWithValue("@Manglik", "gdfgg");
cmdins.Parameters.AddWithValue("@Gotra", "fsdfsdf");
cmdins.Parameters.AddWithValue("@Nakshtra", "dsfsdf");
cmdins.Parameters.AddWithValue("@Guna", "dvssv");
cmdins.Parameters.AddWithValue("@Youni", "svsvsv");
cmdins.Parameters.AddWithValue("@Nadi", "svdsvsv");
cmdins.Parameters.AddWithValue("@Drinking", "fccsdvv");
cmdins.Parameters.AddWithValue("@Smoking", "ssdvsvs");
cmdins.Parameters.AddWithValue("@Eating", "svsdvsdv");
cmdins.Parameters.AddWithValue("@Profile_Created_By", "svsvsv");
cmdins.Parameters.AddWithValue("@Image_Name", "img_01.jpeg");
cmdins.Parameters.AddWithValue("@Image_Path", "~/ProfileImages/" + "img_01.jpeg");
cmdins.Parameters.AddWithValue("@IsActive", 1);

dint got any error..
Raj.Rautela 23-Jan-13 0:58am View
   
yes sir every dropdown is populated on page load..
Raj.Rautela 23-Jan-13 0:47am View
   
cmdins.Parameters.AddWithValue("@Moon_Rashi", ddlmoonraashi.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@Manglik", rbtnlmaanglik.SelectedItem.Text);

here it is showing error
Raj.Rautela 7-Jan-13 2:13am View
   
thank u very much sir got it...thanks a lot...
Raj.Rautela 7-Jan-13 1:50am View
   
m not having idea about how to put key on the url can u pls give me same example..
Raj.Rautela 22-Nov-12 6:16am View
   
sir i got 1 solution soved my prblm by this..but thanks for your help sir.thanks a lot
DataRowView drv = e.Row.DataItem as DataRowView;
if (e.Row.RowType == DataControlRowType.DataRow)
{

if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
CheckBoxList chkame = (CheckBoxList)e.Row.FindControl("chklamenities");
string[] strSplitArr = ((DataRowView)e.Row.DataItem)["Amenities"].ToString().Split(',');
foreach (ListItem oItem in chkame.Items)
{
for (int i = 0; i < strSplitArr.Length; i++)
{
if (oItem.Value == strSplitArr[i].Trim())
{
oItem.Selected = true;
break;
}
}
}
}
}
Raj.Rautela 22-Nov-12 5:46am View
   
there are 3 errors
1)
'System.Web.UI.WebControls.GridViewRowEventArgs' does not contain a definition for 'RowIndex' and no extension method 'RowIndex' accepting a first argument of type 'System.Web.UI.WebControls.GridViewRowEventArgs' could be found (are you missing a using directive or an assembly reference?)

2)
'System.Data.DataSet' does not contain a definition for 'Table' and no extension method 'Table' accepting a first argument of type 'System.Data.DataSet' could be found (are you missing a using directive or an assembly reference?)


3)
foreach statement cannot operate on variables of type 'System.Web.UI.WebControls.CheckBoxList' because 'System.Web.UI.WebControls.CheckBoxList' does not contain a public definition for 'GetEnumerator'
Raj.Rautela 22-Nov-12 5:33am View
   
sorry sir its not working for me...
Raj.Rautela 22-Nov-12 3:59am View
   
sir for update it worked but onedit command previously entered values are not retrived in checkboxlist
Raj.Rautela 22-Nov-12 3:28am View
   
sir i'hv updated my question have a look
Raj.Rautela 22-Nov-12 3:17am View
   
sir i tried what u told but still not working for me.i'hv updated my question pls have a look...thanks sir
Raj.Rautela 21-Nov-12 12:17pm View
   
thanks sir
Raj.Rautela 21-Nov-12 12:16pm View
   
thanks sir got it now thanks a lot...
Raj.Rautela 21-Nov-12 11:37am View
   
m not getting u sir can u pls give same example..
Raj.Rautela 3-Nov-12 5:05am View
   
m storing image path in database and image in a folder in the root file..can u pls tell me what should i do.how to bind images to li dynamically.
Raj.Rautela 3-Nov-12 5:01am View
   
can u give me an example how to use ul li..and bind images from database to li..
Raj.Rautela 26-Oct-12 11:29am View
   
sir i can understand what u r saying..it depends on browser setting of the user.
Raj.Rautela 26-Oct-12 4:03am View
   
sir actully i changed the question but forgot to change the subject sorry..pls read my question once more..
Raj.Rautela 26-Oct-12 1:10am View
   
sir i know what u r saying..but it is the requirement of client pls tell me any solution if possible how we can achieve this.open page in new window or new tab..
Raj.Rautela 25-Oct-12 13:46pm View
   
but if i want to open in new tab in my browser just for testing purpose what should do..
Raj.Rautela 18-Oct-12 7:56am View
   
thanks sir
Raj.Rautela 18-Oct-12 7:56am View
   
thanks sir
Raj.Rautela 18-Oct-12 7:24am View
   
thanks sir..
Raj.Rautela 16-Oct-12 13:48pm View
   
m not getting from this example..can u pls give some other sample.
Raj.Rautela 4-Oct-12 23:41pm View
   
thanks u sir....
Raj.Rautela 4-Oct-12 10:34am View
   
Deleted
Fill: SelectCommand.Connection property has not been initialized.
Raj.Rautela 4-Oct-12 10:30am View
   
Deleted
m doing like this to bind listview on searcresult page by dt store in session
SqlConnection con = new SqlConnection(str);
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
dt = Session["Search"] as DataTable;
da.Fill(dt);
listview1.DataSource = dt;
listview1.DataBind();
but it is showing error..
Raj.Rautela 4-Oct-12 10:05am View
   
Deleted
Sir got te values in datatable in stored it in Session but now how to bind these values to listview on another page..
Raj.Rautela 4-Oct-12 9:44am View
   
Deleted
tell me how can i store my search result in datatable..
Raj.Rautela 4-Oct-12 9:43am View
   
Deleted
sir but i debugged the code there it is no data in Datatable...
Raj.Rautela 4-Oct-12 9:37am View
   
Deleted
SqlConnection con = new SqlConnection(str);
string strQ = ("select s.Property_Type,C.City_Name,L.Locality_Name,s.Price,s.Bedrooms,s.Area From tbl_post_property_sale as s inner join tbl_City as C on C.City_Id=s.City_id inner join tbl_Locality as L on L.Locality_Id=s.Locality_Id where s.Property_type='" + ddlpropertytype.SelectedItem.Text + "'and C.City_Id=" + ddlcity.SelectedValue + " and L.Locality_Id=" + ddllocality.SelectedValue + " and s.price between " + ddlminprice.SelectedValue + " and " + ddlmaxprice.SelectedValue + " and s.Bedrooms=" + ddlbedrooms.SelectedItem.Text + " and s.Area between '" + (txtminarea.Text).Trim() + " " + ddlarea.SelectedItem.Text + "'and '" + (txtmaxarea.Text).Trim() + " " + ddlarea.SelectedItem.Text + "'");
SqlCommand cmdsearch = new SqlCommand(strQ, con);
con.Open();
cmdsearch.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(strQ,con);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();

this is the way to fill result in dt..m i correct or wrong..
Raj.Rautela 4-Oct-12 8:46am View
   
Deleted
sir can u give me an example howw to store my result in session.and how to retrive it on another page
Raj.Rautela 4-Oct-12 8:42am View
   
Deleted
sir can pls give one example....
Raj.Rautela 3-Oct-12 8:30am View
   
m having a property in my databse whose price is 80 lakhs and i want to display that proerty bcoz it is in the range of 75 to 85...but not getting the logic how to get that...everything else is working proper but price column is having prblm...
Raj.Rautela 3-Oct-12 8:27am View
   
sir i want to find a property from database whose price range is between 75 to 85 lakhs..whatever u told i'hv done that the error is at price column m not getting how to find property by price range..
Raj.Rautela 3-Oct-12 7:21am View
   
hey hello Tejas sir i'hv pasted my dought look at this query pls help..
Raj.Rautela 3-Oct-12 6:52am View
   
SqlConnection con = new SqlConnection(str);
string strQ = ("Select P_ID, Property_Type,City_Name,Locality_Name,Price,Build_up_area,Bedrooms,Property_Image From tbl_post_property_sale,tbl_City,tbl_Locality where tbl_post_property_sale.City_Id=tbl_City.City_Id and tbl_post_property_sale.locality_Id=tbl_Locality.locality_Id and Property_Type like '" + ddlpropertytype.SelectedItem.Text + "',City_Name like '" + ddlcity.SelectedItem.Text + "',Locality_Name like '" + ddllocality.SelectedItem.Text + "'Bedrooms like '" + ddlbedrooms.SelectedItem.Text + "' and Price between '" + ddlprice.SelectedItem.Text + "'");
SqlCommand cmdsearch = new SqlCommand(strQ, con);
con.Open();
cmdsearch.ExecuteNonQuery();
con.Close();

m writing this query to search but not getting any output something is wrong in price range..
Raj.Rautela 3-Oct-12 6:23am View
   
Deleted
in my database data is stored like this...
P_ID Property_Type City_Id Locality_Id Address Pincode Price Bedrooms Build_up_area Key_Features Property_Image Name Email Mobile_No
----------- -------------------------------------------------- ----------- ----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- -------------------- ----------- -------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ---------------------------------------
10 Residential 1 1 Kharghar East 456324 90 Lakh 2 800 sqft Gym,Swimming 0xFFD8FFE1001845786966000049492A00080000000000000000000000FFEC00114475636B7900010004000000320000FFEE000E41646F62650064C000000001FFDB008400080606060606080606080C0807080C0E0A08080A0E100D0D0E0D0D10110C0E0D0D0E0C110F12131413120F18181A1A181823222222232727272727 XYZ xyz@gmail.com 1234567890
12 Commercial 1 5 Vashi Near XYZ mall 123455 10 Crores 0 2000 sqft Near to stn 0xFFD8FFE000104A46494600010100000100010000FFDB0084000906061212111414131414151415151617161718131E181415141416151715161617181B281E1819231C1614202F202427292C2C2C161F3135302A35262B2C2901090A0A0E0C0E1A0F0F1A2E1C1C1F292C2A2C29292C292C2C29292929292C29292C2C2C292C ascd abcd@gmail.com 1234567890
Raj.Rautela 30-Sep-12 13:44pm View
   
got it sir thanks a lot......sir
Raj.Rautela 30-Sep-12 13:10pm View
   
DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'City_Id'. getting this error do i have to chage code in generic file also...
Raj.Rautela 30-Sep-12 12:11pm View
   
sir other things are same as i pasted earlier...handler,code behind, form design etc..
Raj.Rautela 30-Sep-12 12:10pm View
   
create table tbl_Locality
(
Locality_Id int identity(1,1)primary Key,
Locality_Name varchar(50)not null
)
Raj.Rautela 30-Sep-12 12:10pm View
   
create table tbl_City
(
City_Id int identity(1,1)primary key,
City_Name varchar(50)not null
)
Raj.Rautela 30-Sep-12 12:09pm View
   
create Table tbl_post_property_sale
(
P_ID int identity(1,1)primary key,
Property_Type varchar(50)not null,
City_Id int references tbl_City(City_Id) not null,
Locality_Id int references tbl_Locality(Locality_Id)not null,
[Address] varchar(200)null,
Pincode numeric null,
Price varchar(20) not null,
Bedrooms int null,
Build_up_area varchar(20) not null,
Key_Features varchar(200)null,
Property_Image image not null,
Name varchar(50)not null,
Email varchar(50)not null,
Mobile_No numeric not null
)
Raj.Rautela 30-Sep-12 11:31am View
   
sir i want to display city name and locality name not city id and locality id on display page it is showing city id and locality id m filling city and locality dropdown from diff table how to join..i'hv created a relation pk and fk pls help in sql joins
Raj.Rautela 30-Sep-12 9:21am View
   
thank u sir got it thanks a lot...
Raj.Rautela 30-Sep-12 9:15am View
   
i did what you told but image is no there only details are there
Raj.Rautela 30-Sep-12 4:03am View
   
issue is m not having any idea how to write code for my search from and display search result in datalist or listview..
Raj.Rautela 28-Sep-12 8:16am View
   
thanks sir...i'll try this also..
Raj.Rautela 28-Sep-12 8:10am View
   
thank u sir...
Raj.Rautela 28-Sep-12 8:04am View
   
but pls tell me where i was wrong....
Raj.Rautela 28-Sep-12 8:04am View
   
got it sir thank u so much....
Raj.Rautela 28-Sep-12 8:01am View
   
pls wait sir i'll try...
Raj.Rautela 28-Sep-12 7:50am View
   
Deleted
m not getting u
Raj.Rautela 28-Sep-12 7:49am View
   
m getting value mumbia..when debugged the code line by line..
Raj.Rautela 28-Sep-12 7:47am View
   
sir wait i'll pasete code how m filling drop down..
SqlConnection cn = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("select * from tbl_City", cn);
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read() == true)
{
ddlcity.Items.Add(new ListItem(dr["City_Name"].ToString(),dr["City_Id"].ToString()));
}
dr.Close();
cn.Close();

Raj.Rautela 28-Sep-12 7:45am View
   
SqlConnection con = new SqlConnection(str);
SqlCommand cmdins = new SqlCommand("dbo.Post_Requirement_Buy", con);
cmdins.CommandType = CommandType.StoredProcedure;
cmdins.Parameters.AddWithValue("@Property_Type", ddlpropertytype.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text));
cmdins.Parameters.AddWithValue("@Locality_Id",Convert.ToInt32(ddllocality.SelectedItem.Text));
cmdins.Parameters.AddWithValue("@Min_Price", ddlminprice.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@Max_Price", ddlmaxprice.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@Bedrooms", Convert.ToInt32(ddlbedrooms.SelectedItem.Text));
cmdins.Parameters.AddWithValue("@Build_up_area", txtarea.Text + ' ' + ddlarea.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@Key_Features", txtfeatures.Text);
cmdins.Parameters.AddWithValue("@Name", txtname.Text);
cmdins.Parameters.AddWithValue("@Email", txtemail.Text);
cmdins.Parameters.AddWithValue("@Mobile_No", txtmobileno.Text);

con.Open();

cmdins.ExecuteNonQuery();

lblmessage.Text = "Submitted Sucessfully";

con.Close();
Raj.Rautela 28-Sep-12 7:45am View
   
SqlConnection con = new SqlConnection(str);
SqlCommand cmdins = new SqlCommand("dbo.Post_Requirement_Buy", con);
cmdins.CommandType = CommandType.StoredProcedure;
cmdins.Parameters.AddWithValue("@Property_Type", ddlpropertytype.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text));
cmdins.Parameters.AddWithValue("@Locality_Id",Convert.ToInt32(ddllocality.SelectedItem.Text));
cmdins.Parameters.AddWithValue("@Min_Price", ddlminprice.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@Max_Price", ddlmaxprice.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@Bedrooms", Convert.ToInt32(ddlbedrooms.SelectedItem.Text));
cmdins.Parameters.AddWithValue("@Build_up_area", txtarea.Text + ' ' + ddlarea.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@Key_Features", txtfeatures.Text);
cmdins.Parameters.AddWithValue("@Name", txtname.Text);
cmdins.Parameters.AddWithValue("@Email", txtemail.Text);
cmdins.Parameters.AddWithValue("@Mobile_No", txtmobileno.Text);

con.Open();

cmdins.ExecuteNonQuery();

lblmessage.Text = "Submitted Sucessfully";

con.Close();
Raj.Rautela 28-Sep-12 7:44am View
   
Deleted
SqlConnection con = new SqlConnection(str); SqlCommand cmdins = new SqlCommand("dbo.Post_Requirement_Buy", con); cmdins.CommandType = CommandType.StoredProcedure; cmdins.Parameters.AddWithValue("@Property_Type", ddlpropertytype.SelectedItem.Text); cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text)); cmdins.Parameters.AddWithValue("@Locality_Id",Convert.ToInt32(ddllocality.SelectedItem.Text)); cmdins.Parameters.AddWithValue("@Min_Price", ddlminprice.SelectedItem.Text); cmdins.Parameters.AddWithValue("@Max_Price", ddlmaxprice.SelectedItem.Text); cmdins.Parameters.AddWithValue("@Bedrooms", Convert.ToInt32(ddlbedrooms.SelectedItem.Text)); cmdins.Parameters.AddWithValue("@Build_up_area", txtarea.Text + ' ' + ddlarea.SelectedItem.Text); cmdins.Parameters.AddWithValue("@Key_Features", txtfeatures.Text); cmdins.Parameters.AddWithValue("@Name", txtname.Text); cmdins.Parameters.AddWithValue("@Email", txtemail.Text); cmdins.Parameters.AddWithValue("@Mobile_No", txtmobileno.Text); con.Open(); cmdins.ExecuteNonQuery(); lblmessage.Text = "Submitted Sucessfully"; con.Close(); input type not in correct format error sir...at cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text));
Raj.Rautela 28-Sep-12 7:43am View
   
SqlConnection con = new SqlConnection(str);
SqlCommand cmdins = new SqlCommand("dbo.Post_Requirement_Buy", con);
cmdins.CommandType = CommandType.StoredProcedure;
cmdins.Parameters.AddWithValue("@Property_Type", ddlpropertytype.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text));
cmdins.Parameters.AddWithValue("@Locality_Id",Convert.ToInt32(ddllocality.SelectedItem.Text));
cmdins.Parameters.AddWithValue("@Min_Price", ddlminprice.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@Max_Price", ddlmaxprice.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@Bedrooms", Convert.ToInt32(ddlbedrooms.SelectedItem.Text));
cmdins.Parameters.AddWithValue("@Build_up_area", txtarea.Text + ' ' + ddlarea.SelectedItem.Text);
cmdins.Parameters.AddWithValue("@Key_Features", txtfeatures.Text);
cmdins.Parameters.AddWithValue("@Name", txtname.Text);
cmdins.Parameters.AddWithValue("@Email", txtemail.Text);
cmdins.Parameters.AddWithValue("@Mobile_No", txtmobileno.Text);

con.Open();

cmdins.ExecuteNonQuery();

lblmessage.Text = "Submitted Sucessfully";

con.Close();

input type not in correct format error sir...at
cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text));
Raj.Rautela 28-Sep-12 7:41am View
   
now m getting input type not in corrent format
error
cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text));
Raj.Rautela 28-Sep-12 7:23am View
   
sir tried your ans it is giving error input string not in corrent format.
cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text));
Raj.Rautela 28-Sep-12 6:18am View
   
thanks for the ans...i'll do that...
Raj.Rautela 28-Sep-12 6:17am View
   
thanks for improving my question sir...error is in parameters i think m passing wrong parameters...i got 3 ans here i'll try them and get back to u..thanks again...
Raj.Rautela 28-Sep-12 6:15am View
   
thanks sir...i'll try your suggestion.i'll give my feed back to u...thanks a lot..!!!
Raj.Rautela 28-Sep-12 6:14am View
   
thanks sir...i'll try your suggestion..thanks a lot..
Raj.Rautela 28-Sep-12 6:13am View
   
thanks sir...i'll try your suggestion..thanks a lot..
Raj.Rautela 15-Sep-12 14:00pm View
   
i want to save data entered by user on the form to database.mandatory fields are compulsory to fill but what about non mandatory fields.its upto user to fill or not..what type of query i should write.if user fills mandatory fields and or not filling mandatory fields...if the user fill that field then that value will be stored in the database but if user is not filling that field that what value will be stored in database...i got another ans to use not null and null constraints..
Raj.Rautela 15-Sep-12 13:54pm View
   
thanks sir i'll try your suggestion..
Raj.Rautela 15-Sep-12 13:53pm View
   
m asking for an example from your side to solve my prblm...if possible help..thanks
Raj.Rautela 9-Sep-12 12:27pm View
   
Deleted
thanks sir..
Raj.Rautela 9-Sep-12 12:27pm View
   
thanks sir..
Raj.Rautela 9-Sep-12 12:27pm View
   
thanks sir
Raj.Rautela 9-Sep-12 12:26pm View
   
thanks sir
Raj.Rautela 5-Sep-12 12:20pm View
   
thanks sir..
Raj.Rautela 5-Sep-12 12:20pm View
   
thanks sir...

Advertise | Privacy | Cookies | Terms of Service
Web04-2016 | 2.8.180906.1 | Last Updated 1 Jan 1900
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid