Comments by Naina2 (Top 24 by date)

my proc one code is not calling by the debbuger

left side variable ??

this is the proc


public string UpdateLeadmanage(DTOLeadManage dto)
{

string result = string.Empty;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "proc_update_lead";
cmd.Parameters.AddWithValue("@lead_id", dto.LeadId);
cmd.Parameters.AddWithValue("@enquiry", dto.Enquiry);
cmd.Parameters.AddWithValue("@category_desc", dto.category_description);
cmd.Parameters.AddWithValue("@category", dto.Category_Id);
result = "error";
try
{
con.Open();
cmd.ExecuteNonQuery();

}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return result;
}

this is the webmethod

public string UpdateLeadmanage(int leadId, string enquiry, string desc, string category)
{
DTOLeadManage dto = new DTOLeadManage();
dto.LeadId = leadId;
dto.Enquiry = enquiry;
dto.category_description = desc;
dto.category = category;
DALLeadManagement dal = new DALLeadManagement();
return dal.UpdateLeadmanage(dto);

}

please see above one is my code ..plz have a look

var leadid = ctrl.find('.leadid').val();
var enquiry = ctrl.find('#enquiry').val();
var desc = ctrl.find('#category_desc').val();
var category = ctrl.find('.ddlStage option:selected').val();

var sdata = "{";
sdata += "leadId:'" + leadid + "',";
sdata += "enquiry:'" + enquiry + "',";
sdata += "desc:'" + desc + "',";
sdata += "category:'" + category + "'";
sdata += "}";
$.ajax({
url: 'webservices/LeadManagement.asmx/UpdateLeadmanage',
type: "POST",
dataType: 'json',
cache: false,
contentType: 'application/json; charset=utf-8',
data: JSON.stringify(sdata),
success: function (result) {
alert(result.d);
if (result.d.length > 0 ) {
message.ShowStaticMessage("Lead Detail Update sucessfully", "message");

}
else {
message.show(result.d, 'error');
}
}
});


this is my code

yeah but i m not using any webservice and i m having problem in jquery that only to 25 records when user see the page ..

i am not using gridview . i m using div . so plz tell me the solution on tht

as u can see my code i have done the same , the values i m getting but its having some layout problem there.. thts y not showing anythng

but exhibition name is a column name and you are alerting the same ....is it rite?

my xml string is showing the data .. but in a very weird manner ...it is showing like this :


<string xmlns="http://tempuri.org/"><NewDataSet>
<Table>
<rank1>1</rank1>
<edate>2013-09-22T00:00:00+05:30</edate>
<exhibition_name>BBC Symphony Orchestra</exhibition_name>
<country>United Kingdom</country>
<exhibition_image_path>888.jpg</exhibition_image_path>
<smonth>9,9,</smonth>
<syear>2013,2013,</syear>
<coid>1</coid>
<cityid>1</cityid>
<city>London</city>
<exhibitionid>888</exhibitionid>
<exhibition_desc>&lt;span style="font-family: Arial, Verdana; font-size: small;"&gt;BBC Symphony Orchestra is central to English musical culture. And BBC brings you Symphony Orchestra performance, where highly talented players will play for the audience. Join the multitude of crowd joining this big event at Barbican. Follow the schedule to find out who will be performing when. Barbican is committed to bringing you the best of this genre in sheer passion. It will host 20th century to contemporary music on various dates, by different performers. Learn about the last 80 years of orchestra’s history, and see how it has grown ever since that time. You can book a stay with one of the &lt;a href="http://www.exhibitioncentrehotels.com/hotel-booking/hotels-near-barbican-centre.aspx"&gt;hotels near Barbican Centre in London&lt;/a&gt;, and easily walk down to the venue. Exhibitioncentrehotels has a collection of accommodations available to suit any requirement.&lt;/span&gt;</exhibition_desc>
<industryid>17</industryid>
<country_id>1</country_id>
<industry_name>Entertainment</industry_name>
<industry_page_name>industry/entertainment.aspx</industry_page_name>
<venue_id>7</venue_id>
<page_name>exhibitions/bbc-symphony-orchestra.aspx</page_name>
<venue_name>Barbican Centre</venue_name>
<exhibition_dates>22-Sep-2013 to 25-May-2014,22-Sep-2013 to 25-May-2014</exhibition_dates>
</Table>
<Table>
<rank1>1</rank1>
<edate>2014-02-13T00:00:00+05:30</edate>
<exhibition_name>United Visual Artists: Momentum</exhibition_name>
<country>United Kingdom</country>
<exhibition_image_path>1455.jpg</exhibition_image_path>
<smonth>2,</smonth>
<syear>2014,</syear>
<coid>1</coid>
<cityid>1</cityid>
<city>London</city>
<exhibitionid>1455</exhibitionid>
<exhibition_desc>&lt;font face="Arial, Verdana" size="2"&gt;United Visual Artists presents Momentum, a brand new sound and light installation at Barbican Centre in London. Explore some unique designs and sculptures made with changing pattern of light &amp;amp; sound along with a series of pendulum forms. Experience the change whilst moving through the gallery at your own pace. These changing compositions will represent an internal model of space, movement and mass. If reaching from distant countries and regions, secure a stay with one of the &lt;a href="http://www.exhibitioncentrehotels.com/hotel-booking/hotels-near-barbican-centre.aspx"&gt;finest accommodations near Barbican Centre&lt;/a&gt;. Select from a wide array of lodging options available in vicinity of United Visual Artists.</exhibition_desc>
<industryid>41</industryid>
<country_id>1</country_id>
<industry_name>Telecommunications</industry_name>
<industry_page_name>industry/telecommunications.aspx</industry_page_name>
<venue_id>7</venue_id>
<page_name>exhibiti

no its not a column

basically there is a procedure , i m using for retrieving the data ..and there are joins in the same .. so what would be the benefit of having column names

now it is not showing error but the result is not showing also.. it is not displaying anything

DamithSL : it is showing error like this :

uncaught exception: Invalid XML: undefined

there is the code above one .which is occuring problem to me .please check the above code .its giving exception that the null value cant be inserted into the column .

here is my two radiobutton list and i want tht both should be selected and on second radiobuttonlist selection the today date should be inserted n the table

here is my code check this out ..

protected void Button2_Click(object sender, EventArgs e)
{

string selectValue1 = this.RadioButtonList1.SelectedValue;
string selectValue3 = this.RadioButtonList2.SelectedValue;
string selectValue2 = DateTime.Now.ToString();

string str = ConfigurationManager.AppSettings["con"].ToString();

using (SqlConnection conn = new SqlConnection(str))
{
string sql = "insert into PackSelect (PackSelection) values (@value1)";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@value1", selectValue1);
if (RadioButtonList2.SelectedIndex == 0)
{
string str1 = "insert into PackSelect (ActivePlanDateper) values (@value2)";
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = conn;
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = str1;
//cmd1.Parameters.AddWithValue("@value2", selectVal);
cmd1.Parameters.AddWithValue("@value2", selectValue3);
}
if (RadioButtonList2.SelectedIndex == 1)
{
string str1 = "insert into PackSelect (ActivePlanDatethree) values (@value1)";
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = conn;
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = str1;
//cmd1.Parameters.AddWithValue("@value1", selectVal);
cmd1.Parameters.AddWithValue("@value1", selectValue3);
}
try
{
if (conn.State != ConnectionState.Open)
conn.Open();
int result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}

}
Label27.Text = "Pack Activated successfully!!!";