why listview selecteditem templete call the "select qry" method two time..?
i used objectdata source for show selected item templete which use select method of dataaccess leyer..
how to do this when the checkbox in listview layout template check select all checkboxes in listview itemtemplate.I dont give 'Eval 'field to checkbox present in itemtemplate.
View 3 Replies[Code]....
How to call javascript method in client template (http://github.com/jquery/jquery-tmpl)
I need to create a 'select/open file' template so it can easily be pulled into any page by any other Developer.
View 31 RepliesHow to select data from database to listview using a web method?
View 7 RepliesI ve just added quartz.net dll to my bin and started my example... How to call a c# method using quartz.net based on time?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Quartz;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(SendMail())
Response.write("Mail Sent Successfully");
}
public bool SendMail()
{
try
{
MailMessage mail = new MailMessage();
mail.To = "test@[URL]";
mail.From = "sample@[URL]";
mail.Subject = "Hai Test Web Mail";
mail.BodyFormat = MailFormat.Html;
mail.Body = "Hai Test Web Service";
SmtpMail.SmtpServer = [URL];
mail.Fields.Clear();
mail.Fields.Add([URL], "1");
mail.Fields.Add([URL], "redwolf@[URL]);
mail.Fields.Add([URL], "************");
mail.Fields.Add([URL], "465");
mail.Fields.Add([URL], "true");
SmtpMail.Send(mail);
return (true);
}
catch (Exception err)
{
throw err;
}
}
}
Here i am just sending a mail on page load. How to call SendMail() once in a day at a given time (say 6.00 AM) using quartz.net. I dont know how to get started? Should i configure it in my global.asax file.
Currently I run 2 separate queries to update + retrieve a tickent number. What happens if there're 2 users clicking on the same button at the same time? Could somehow two updates being run first and then both users get back the same ticket number?
string mySql = "UPDATE TicketCounter SET TicketNumber = (TicketNumber + 1)";
OleDbConnection myConnection = new OleDbConnection(accessConnStr);
OleDbCommand myCmd = new OleDbCommand(mySql, myConnection);
myCmd.Connection.Open();
myCmd.ExecuteNonQuery();
mySql = "SELECT TicketNumber FROM TicketCounter"
myCmd.CommandText = mySql;
OleDbDataReader myReader = myCmd.ExecuteReader();
I am using an ObjectDataSource control to call a MapInfo object. This object has two properties:
public IList Visits
public int TotalAvailable
The select method returns an IList but the TotalAvailable property is also populated. I have set the TypeName in the ObjectDataSource to the MapInfo object but because the Select method only returns the IList I don't have access to the TotalAvailable.
[code]....
Is there any way to access this value. I know it is being populated in the MapInfo object but all that gets returned from the Select method is the IList
How do I do this? I want to search my database in listview form with the text from a textbox or an item from a drop down list which is on another page.
View 1 RepliesI give up. After many hours of scouring the internet, cannot find a simple example of binding a simple object to a ListView and figure out which one is selected in the SelectedIndexChanged event.
Many people talk about the SelectedItem and SelectedItems properties; which somehow, according to intellesense, do not even exist on my ListView. I must have a "special .Net build" :)
If I have a collection of "Books" bound to a ListView. How do I get the "selected book" in the SelectedIndexChanged event? (Multiselect = false)
I would think it's something like:
Book MyBook = (Book)ListView1.SelectedItem
I'd even settle for
Book MyBook = (Book)ListView1.SelectedItems[0]
No such luck. My very special ListView does not seem to have either property.
I'm implementing a BLL layer and have a few questions. First, in my DAL, there is a contacts table, the select method is a sql query against a sql server 2000 database. The preview data returns everyting as expected. The query is
[Code]....
The BLL method is built like so
[Code]....
When using the BLL method to a gridview, the results of the subquery are not displayed. There are also other methods, each having a different where clause for ContactRole_ID and each is having the same issue of not displaying the subquery reult in the gridview. No error, but no data is displayed for the subquery either. Here is the templatefield of the gridview
[Code]....
Another item that is causing an error is in trying to update a record. Here is the DAL update method
[Code]....
And the BLL update method
[Code]....
The error says i have extra parameters, but have no clue where the extra parameters are being picked up. The error isObjectDataSource 'odsContacts' could not find a non-generic method 'UpdateContact' that has parameters: _ContactID, _Active, _ContactName, _Office, _VirtualOffice, _Pager, _Fax, _Home, _Cellular, _Email, _ContactRole_ID, Active, ContactRole_ID, ContactName, Office, Email, VirtualOffice, Pager, FAX, Home, Cellular.And the objectdatasource
[Code]....
I am having 3 ListBoxs(LB1,LB2,LB3).In LB1 I am binding the names of Courses through database.The code is shon below...
da1 = new SqlDataAdapter("SELECT COURSE_ID,COURSE_NAME FROM Course_Mst", con);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
lstCourse.DataSource = dt1;
lstCourse.DataValueField = "COURSE_ID";
lstCourse.DataTextField = "COURSE_NAME";
lstCourse.DataBind();
Whenever I select particular course in LB1 all the content related to that course will be binded in LB2.The code is shown below.....
protected void LB1_SelectedIndexChanged(object sender, EventArgs e)
{
da2 = new SqlDataAdapter("SELECT SPEC_ID,SPEC_NAME FROM SPEC_TRANS WHERE COURSE_ID="+Convert.ToInt32(lstCourse.SelectedValue)+"", con);
DataTable dt = new DataTable();
da2.Fill(dt);
lstSpecilization.DataSource = dt;
lstSpecilization.DataValueField = "SPEC_ID";
lstSpecilization.DataTextField = "SPEC_NAME";
lstSpecilization.DataBind();
lstSpecilization.Focus();
}
I am having a ADD button.In LB2 I can select multiple items.When I select multiple items in LB2 and click on ADD all the selected items will be binded into LB3.The code is shown below...
protected void btnAddCourseDetaisl_Click(object sender, EventArgs e)
{
for (int intLoopIndex = 0; intLoopIndex <lstSpecilization.Items.Count ; intLoopIndex++)
{
if (lstSpecilization.Items[intLoopIndex].Selected)
{
ListItem li = new ListItem(lstSpecilization.Items[intLoopIndex].Text, lstSpecilization.Items[intLoopIndex].Value);
LB3.Items.Add(li);
}
}
}
My problem is when I select a item from LB2 and click on ADD the selecteditem is added to LB3 but if I select the same item and click on ADD the items are again added to the LB3.I want to prevent this.Pls respond me ASAP.
I have an ActiveX object which extends some functions. I have a web page that loads the ActiveX object and calls its methods in Javascript. The ActiveX object has two method; the problem is that Javascript can successfully call one of them but fails to call the other; citing Object doesn't support this property or method which is nonsense because I made a VB6.0 application that successfully calls this other method, so the two functions are indeed extended correctly and performing their job. And yes, the Internet Explorer security zones are all set and everything, as I wrote above the javascript code can call one method but refuses to call the other.
View 1 RepliesI am simply trying to change the listView template based on a value in the listview data. I do have this displaying the information correctly. Except when I try to change the item template based on a value in the listview. My code is below ....
View 6 RepliesThe drop down list is used to determine what search criteria will be used to find an invoice. I tried to set the Select method in the switch statement. I don't understand how to set the Select Method and the select parameters programmatically though . I tried a few different ways but can't make the compiler happy. My ODS is in scope in the code behind. I'm not able to access it's properties though. The BAL resides in a separate project that is a ClassLibrary. I also have a using statement for the ClassLibrary project in the code behind.
give me an example of how to do this?
Mark up:
[Code]....
[Code]....
[Code]....
[Code]....
protected void Button19_Click(object sender, EventArgs e)
{
SqlDataSource conn = new SqlDataSource();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["Database2ConnectionString1"].ToString();
conn.SelectCommandType = SqlDataSourceCommandType.Text;
conn.SelectCommand = "SELECT FROM table1 (a, b)VALUES(@a,@b)";
conn.SelectParameters.Add("a",TextBox1.Text);
conn.SelectParameters.Add("b", TextBox2.Text);
int rowsAffected = 0;
try
{
rowsAffected = conn.Selectt();
}
catch (Exception)
{
Label1.Text = "Error";
}
finally {
conn = null;
}
if (rowsAffected != 0)
{
Label1.Text = "Data saved";
}
}
well it returns error no overloading method for select (P.S. same code work fine for insert)
I want to execute a certain piece of code by default before each web Method.
Without adding any extra code in each method how to achieve this?
I am calling this service from Win application.
I have a web method in my code behind:
[System.Web.Services.WebMethod]
public static string GetStateData(string state)
{
//this is where i want to call a javascript method "GetItems"
}
I have a javascript method that retrieves some values for me and I want to get use one of those values in my web method
function GetItems() {
var variable1= $("#<%=Item1.ClientID %> input:checked");
var variable2= $("#<%=Item2.ClientID %>").val();
return [variable1.text(), variable2.val(), variable2];}
I've searched for ways to call the javascript method from the web method but every time my search results in how to call a web method from javascript.
I did find this but it was done from the code-behind of a silverlight project and when I tried adding the correct reference to my code-behind it wasn't there
var result = HtmlPage.Window.Invoke("GetItems"); Is there a reference I'm missing?
$("#Name").on("blur", function() {
if (Name != "" && Name != null) {
var options = {
type: "POST",
url: "ApplyNow.aspx/CheckName",
[code]...
how to use the value of 'duplicate' in btnsunmit_click() from webmethod.
I am moving to the world of ASP.NET from an Access VBA / VB6 background and having read a few books on the subject I am still confused about communicating with SQL server in VB with ASP.NET.
As a very quick explination I am used to communicating with the server by passing strings containing the data I want to write (or read) such as:
[Code]....
I do not seem to be able to work out from ALAX, Dynamic Data, Bound Controls, DataViews, connecting to services with SOAP, DataSources and all of the other methods of database communication in ASP.NET which is the right system to do the simple reads and writes in SQL that I want to do.
At present I have a page with all of the controls on it required to collect a block of data I want to insert, it is all now fully validated but although I can build the SQL INSERT command in a string I cannot figure out how to fire it over to the local SQL Express server. Am I even doing this correctly or do I need to look at other controls?
i have two tables named
1.LookupPageInfo and (LookupPageInfoId,pathmessageID,pagemessageID)
2.Messages (MessageId,MessageText,ChannelID)
Now i need to write a query something like this........in the query i need to pass the pathmessageid and needs to get messagetext from Messages Table,i am not sure how i need to write the below query..can someone guide me how can i write a query......as below..
select LookupPageInfoId,
PathMessageID,
pagemessageID,
(select messagetext from Messages where MessageID=PathmessageId) as TEXT from LookupPageInfo
What is difference between select { } and select new {} In Linq Query
View 3 RepliesI create a static website , but i want to master page, i select one flash template but i dont how to edit flash template.
View 1 RepliesI am writing a linq query to select a blogpost,
[code]....
The blogpost i am testing got 3 tags attached to it. The table structure is:
(table)BlogPost -> (table)BlogPostTags <- (table)Tags
So the BlogPostTags table only contains 2 fields, BlogPostID and TagID.
When i run the query above i get 3 results back. Same blogpost 3 times but with 1 tag in each. It should return 1 post with 3 tags. The problem lies in the Tags query above.
How can I SELECT second if first SELECT returns nothing?
View 8 Replies
