MeSampath

Hi, I need to retrieve only 1 row for each 'message_id', with the Latest Date('sent_date'): ------------------------------------- message_id | sent_date | ------------------------------------- 805 | 2010-08-04 17:48:24 | <--- 805 | 2010-08-03 17:48:24 | 1007 | 2010-08-07 17:48:24 | 1007 | 2010-08-09 17:48:24 | <--- 1007 | 2010-08-08 17:48:24 | ------------------------------------- The …

What do I need that I can add a reference to System.Windows.Controls namespace?

hi I have an access database, which I connect it to the form I have text boxes which displays info from the fields in the database. I have created a "Next", and "Previous" button, which the user can move between the database info but i don't know the code for …

hie m using visual studio 2005 and sql 2005 i want to export my sql database to excel..

Hi, I got error "No value given for one or more required parameters" error when executing the following code. I checked the value of the query and it seems correct. Does anyone know why? [CODE]string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Catherine\\Documents\\LearningCSharp.accdb"; OleDbConnection myConnection = new OleDbConnection(connectionString); myConnection.Open(); int employeeNumber = int.Parse(textBox1.Text); string name …

I am having a problem with the sql update statement in c#. This click event tests between either "edit" or "new" mode and then uses the proper sql statement. The Insert statement works fine but the Update statement does not update. I created a break point and stepped thru and …

Hi I am new to C#. I have to enable my text box whn the check box is checked. It would be very helpful if i can get the code for this.

hi, my table has following fields ForumPostsId(primary key),ForumPost,ParentPost parentpost can have 0(which means its parentpost) or ForumPostsId(which means its a chlid post related to parentpost) i need to generate a list which will the show parentpost and count of child post related to parent post Any suggestion!!!!!!!!! regards rajan

Hello ! I'm trying to edit and update and cancel in datagrid. Edit and cancel commands are working properly but at UPDATE i m getting this error.(Incorrect syntax near '12'). Please help me. my code is here.. [code] protected void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e) { num = Convert.ToInt16(e.Item.Cells[1].Text.ToString()); TextBox t1, …

Hello, in my program i want to read data from text file and display the data as keyvalue pair using console application. i am using below code to read the data [code]{ string[] lines = System.IO.File.ReadAllLines(@"C:\Users\ramy\desktop\grocery billing.txt"); System.Console.WriteLine("Contents of grocery billing.txt :"); foreach (string line in lines) { Console.WriteLine(line); // …

I got an error when i run my program. it says; you have an error in your sql syntax;check the manual that corresponds to your mySQL server version for the right syntax to use near 'VALUES ('2011',5,5131,678,'342',809 at line 1 what does it mean? here's my code. can someone point …

Can anyone help me how to load an external page into a <div> tag? I've search the internet and still no answers.. please give me an example.. I have not started a thing yet...

Hai , I have 2 tables 1. [B]Transport_Details[/B] having columns user_id FareStageId StartDate EndDate and 2. [B]Route_Fee[/B] having columns FareStageId monthId fees I need to get a monthwise list by passing monthid. My problem is that , if start date and enddate of a user are 02-08-2011 and 20-02-2012 and …

Hi there, I'm working on someone else's site, and I need to add something to their form to make sure that the email address people enter is the correct format (i.e. it has a @ sign and a "."). It currently only checks if there is anything in the field …

I have tried this : [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers left join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] this [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers inner join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] error is : Subquery returned more than 1 …

hai everyone, i have a problem when i want to update from gridview the error message is display Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about …

Hello, The issue that I am having right now is that I have a multiview form that steps through gathering information from the user and depending on the information selected, some fields are displayed/hidden in other views of the form. Basically, what is going on is that I have a …

Hi, I have two tables. Payment and expense. 1. select sum(amount) from payment gives me total payment amount 2. select sum(amount) from expense gives me total expense. 3. I want to join payment and expense table. How can i subtract query1 minus query2 in one join query? Thanks.

I have problem with the convert button please help Thanks in advance [CODE] <html> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8"/> <script type="text/javascript"> var th = ['',]; var dg = ['zero', 'ichi', 'ni', 'san', 'yon', 'go', 'roku', 'nana', 'hachi', 'kyuu']; var tn = ['juu', 'juuichi', 'juuni', 'juusan', 'juushi', 'juugo', 'juuruko', 'juushichi', 'juuhachi', 'juuku']; …

I have a table which has a field ItemsReceived of type datetime. I have a grid view which has two columns. In first column i have to show the data from field ItemsReceived and in second column I have to show difference between Currenttime and date from ItemReceived. How can …

Hi guys I am writing an application in c# I want to create a dynamic log file which would contain all the errors or exceptions occurred during execution of the Component. Log file simply has to append all the errors or exceptions generated with error details and time and date. …

Hi I am developing windows application using C#.There is combo box in the windows application ,once user select value it automatically generate pop window.I want to appear the new window at the right side lower corner in combo box.I tused below coding ,but it never works,please let me know how …

Hi friends, I had a database table as follows ... Id | Film Name | Director | Cast | ---------------------------------------- 12 | Dhoom | Name | 123,128,125,458,12 12 | Dhoom 2 | Name | 129,158,147,455 ------------------------------------------------ I need search by cast column For eg : If I select :- [ICODE]select …

I am trying to write a trigger that updates a column called CUST_BALANCE in a table called CUSTOMER when new data is entered into another table called INVOICE. What I want to do is when new data is inserted into INVOICE it will take the value in column INV_AMOUNT and …

i have exception Conversion from string "System.Web.UI.WebControls.TextBo" to type 'Integer' is not valid. on these line [CODE] Dim no_single_room As Int32 = CType(DirectCast(dataItem.FindControl("txt_single"), TextBox).ToString(), Int32) Dim no_double_room As Int32 = CType(DirectCast(dataItem.FindControl("txt_double"), TextBox).ToString(), Int32) [/CODE]

ca any one correct my insert query in database [code] Dim hotel_book As String = "insert into hotelbooking (Userid, hotel_requirement_Types, singleroom, single_no_room,doubleroom,double_no_room) " & _"VALUES (" & userid & ", '" & ckchecked.Text & "' , & singlecheck & , & no_single_room & , & doublecheck & , &no_double_room & …

I have function that returns string and that works fine but when I call that function from another procedure when it executes function I get a message: [B],,Conversion from 'result' to type 'Integer' is not valid,,[/B] ASP debugger says: [B],,Input string was not in a correct format. ,,[/B] I tried …

Hello Frnds, I have an application developed in ASP.Net(C#) and MS SQL, its working fine and fulfilling the requirements. Now the problem is I have a [I]MS Access Database[/I] from where I have to read some data and feed it into ASP.Net form and then save it to [I]MS SQL …

Hi all. I want to ask about storing the photos in a MySql database. I am developing a Software for Tours & Traveling company in that i need to store the photos of the customer. The further requirement is to export the database to an Excel sheet including the photo. …

i have a problem generating auto number. can someone help me to solve this? here is my code [CODE]Try If IsConnected() = True Then strSQL = "Select max(*) from Supplier" End If myCmd.CommandText = strSQL myCmd.Connection = myConn myDA.SelectCommand = myCmd myDR = myCmd.ExecuteReader() If myDR.HasRows Then Label5.Text = myDR.Item(0) …