Comments by Member 10263519 (Top 142 by date)

no, i know it. but am openng forms as,mainform (contains Menustrip(connect,student_IN, student_out)),click on connect(select the port, connect), click on student_in ,then swipe the card (my serialport object is in connect form,if i use serialport_dataReceived event,how can i display received card id in textbox of student_in)

thanks for reply, i was solved it in the same way

ok, solved it by keeping it in button click,

ok, i was solved it another way, without using identity column.

Mysolution is here:
1)String query = "select * from visitor where card_id=@id and out_time is null";
2)String query = "update visitor set out_time=@out where card_id=@id and out_time is null";
3)String query = "insert into visitor(card_id,name,age,address,id_proof,contact_person,purpose,in_time) values(@id,@name,@age,@address,@idproof,@contact,@purpose,@in)";

i didn't get

i solved

when i observe by keeping breakpoint at area in above code.
am getting area value "System.Data.DataRowView"

am not getting what's the problem.

am didn't get plz give some points how to do plz.........

ok ,solved

solved myself

solved myself

Combo Box is not allowing without selecting anything

instead of Insert(), i tried dt.Rows.InsertAt(dr,0);

now it's working

thanq so much

insert() method is not supporting , am getting error.It's winform application,

thanks alot

IndexOutOfRange exception at datetime t=convert.todatetime(rdr["date"])

ok,
but if i use following;

using (MySqlConnection con = new MySqlConnection(ConnectionString))
{

String query = "select DATE_FORMAT(date, '%Y-%m-%d %H:%m:%s') from acc";
MySqlCommand command = new MySqlCommand(query, con);
con.Open();
using (MySqlDataReader rdr = command.ExecuteReader())
{
if (rdr.Read())
{

DateTime t = Convert.ToDateTime(rdr["date"]);
String s = rdr["date"].ToString();

MessageBox.Show("value:" + t);
}
}
}


acc table is having only 1 column

date datetime


giving error as IndexOutofbounds exception
Could not find specified column in results: date

ok thaq for you reply

releaseObject():


private void releaseObject(object obj)
{
try
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
obj = null;
}
catch (Exception ex)
{
obj = null;
MessageBox.Show("Unable to release the Object " + ex.ToString());
}
finally
{
GC.Collect();
}
}

object misValue = System.Reflection.Missing.Value;

is the minValue i used.

i have used following code:
workbook.Close(true, misValue, misValue);
excelApp.Quit();
releaseObject(worksheet);
releaseObject(workbook);
releaseObject(excelApp);
}
catch (Exception p)
{
MessageBox.Show(p.StackTrace);
}

finally
{
if (excelApp != null)
releaseObject(excelApp);
if (workbook != null)
releaseObject(workbook);
if (worksheet != null)
releaseObject(worksheet);
}


now , its asking as,Do you want to save in messagebox , if i press no, immediatly EXcel sheet also closing.


but my requirement is just open the excel file ,no need to save it. if i want i will take it print that's it. how to solve this...

i don't want to save , just i want to watch it out,

ok, it's working by tabing hour as 24 -hour format.(HH)

it's winforms application.that link is giving error it's not opening

it's windows application

if i uncomment it, it's giving error as

Error 1 'System.Windows.Forms.DataGridView' does not contain a definition for 'DataBind' and no extension method 'DataBind' accepting a first argument of type 'System.Windows.Forms.DataGridView' could be found (are you missing a using directive or an assembly reference?)

then how to solve it.

am collecting browsed file into txtbrowse (textbox).

yes, that excel file is corrupted after executing this code am not getting what's happening.

by using above code am unable to open xlsx file.
am getting error as:

Excel cannot open the file 'Copy of New Microsoft Office Excel Worksheet_using.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

yes, when i use http: it is showing "No web site is configured at this address."

but in iis console , under default websites my project folder is showing. what to do

ok , when i enter "inetmgr" iis window is opening .but in browser(chrome),when i enter https://localhost/
it's giving error as:SSL connection error

i have installed iis7, it's showing in control panel add/remove programs, but when i type inetmgr in run it's showing error as "windows canot find inetmgr"

am having windows XP

how to install IIS7.

how to solve it.

<configuration>
<system.web>
<compilation debug="true" targetframework="4.0">

<connectionstrings>
<add name="myConnectionString" connectionstring="Server=localhost;Database=rewards;User ID=root;Password=root;Integrated Security=True;Allow User Variables=true" providername="System.Data.MySqlClient=">

there is no authentication configuration.
only connection string is there



<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=169433
-->

<configuration>
<system.web>
<compilation debug="true" targetframework="4.0">

<connectionstrings>
<add name="myConnectionString" connectionstring="Server=localhost;Database=rewards;User ID=root;Password=root;Integrated Security=True;Allow User Variables=true" providername="System.Data.MySqlClient=">

how can i check authentication mode

not that "No data found "

how to deploy web application in iis v5.1,

am following
http://www.codeproject.com/Articles/280137/How-To-Deploy-a-Web-App-in-IIS but am getting as shown in that

as you said: http://localhost/login.aspx

if i run using above link web application is not running.
what can i do to run my application on iis.

ok now also it's executing , when i debugg
URL is:http://localhost:3038/login.aspx

before installing iis also same url on browser address bar.

not that , i solved it by keeping "Allow user Variables=true" in connection String.

But here the problem is its giving only last 2 records not 3, if i keep 4 instead of 3 , it's giving last records not the latest last record.

ok, but in query only am passing valus, there is no column in table ,but just for clarity am using this column, i need to get last 3 inserted rows for same id.

if i add like you
am getting erropr:

Server Error in '/' Application.

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 ':= 0 + 1 AS row_number FROM transaction JOIN (SELECT 0 := 0) r where card_id='c' at line 1

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: MySql.Data.MySqlClient.MySqlException: 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 ':= 0 + 1 AS row_number FROM transaction JOIN (SELECT 0 := 0) r where card_id='c' at line 1

Source Error:


Line 220: command3.Parameters.AddWithValue("@card", cardid);
Line 221: command3.Parameters.AddWithValue("@curRow", curRow);
Line 222: using (MySqlDataReader rdr3 = command3.ExecuteReader())
Line 223: {
Line 224: if (rdr3.Read())

Source File: E:\Online Billing System\Online Billing System\DataTransaction.aspx.cs Line: 222

Stack Trace:


[MySqlException (0x80004005): 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 ':= 0 + 1 AS row_number FROM transaction JOIN (SELECT 0 := 0) r where card_id='c' at line 1]
MySql.Data.MySqlClient.MySqlStream.ReadPacket() +376
MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +116
MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) +49
MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +135
MySql.Data.MySqlClient.MySqlDataReader.NextResult() +1258
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +2536
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() +32
Online_Billing_System.DataTransaction.Page_Load(Object sender, EventArgs e) in E:\Online Billing System\Online Billing System\DataTransaction.aspx.cs:222
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.225

i know , just by clicking debug , for a form.but i want to type url with parameters , when i hit enter then web form needs to be traced how is it possible......

thanks a lot it's working

am getting error as no overloaded method with 1 parameter

from my device i got the datetime as 08102013223300

but i need to place in mysql table as 2013-10-08 22:33:00

how to do that.

by hosting on web will get www.silicontechlabs.com

and my web page is Transaction.aspx , but how can i get Finance .in the above url.

ok, but my doubt is:

just type that url, then browser should respond TT=1.
webserver internally connects to my application and should update the record then give responce.

it's not website ,it's web application.am very new to .net, don't mine suggest me , can i use master page to the web application. how to use it .almost i was completed my task,shall i add now master page in web application.

thaks for reply

thaks so much i got it..........

everything is executing ,rdr(datareader is showing HasRows=true)but it's not displaying anything even gridview also.

yes, i was tried with adding columns,

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Transaction.aspx.cs" Inherits="Online_Billing_System.Transaction" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="transactionGridView" runat="server" AutoGenerateColumns="False"
>
<columns>
<asp:BoundField DataField="member_id" HeaderText="Member ID" ReadOnly="true" />
<asp:BoundField DataField="card_id" HeaderText="Card ID" />
<asp:BoundField DataField="name" HeaderText="Name" />
<asp:BoundField DataField="paid_amount" HeaderText="Paid Amount" />
<asp:BoundField DataField="due_amount" HeaderText="Due Amount" />
<asp:BoundField DataField="paid_date" HeaderText="Paid Date" />
<asp:BoundField DataField="location" HeaderText="Location" />
<asp:BoundField DataField="phone_number" HeaderText="Phone Number" />


</div>
</form>
</body>
</html>

but its not getting.

i get placed your code ,but i got the error as:


Server Error in '/' Application.

The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[HttpException (0x80004005): The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).]
System.Web.UI.ControlCollection.Add(Control child) +8721975
AjaxControlToolkit.ScriptObjectBuilder.RegisterCssReferences(Control control) +844
AjaxControlToolkit.ScriptControlBase.OnLoad(EventArgs e) +59
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.225

code in transaction.aspx.cs get executed ,i observed that by keeping breakpoint. rdr(Data Reader)
is showing HasRows=true.but the gridview is not displaying

i have added columns as:

<columns>
<asp:BoundField DataField="member_id" HeaderText="Member ID" ReadOnly="true" />
<asp:BoundField DataField="card_id" HeaderText="Card ID" />
<asp:BoundField DataField="name" HeaderText="Name" />
<asp:BoundField DataField="paid_amount" HeaderText="Paid Amount" />
<asp:BoundField DataField="due_amount" HeaderText="Due Amount" />
<asp:BoundField DataField="paid_date" HeaderText="Paid Date" />
<asp:BoundField DataField="location" HeaderText="Location" />
<asp:BoundField DataField="phone_number" HeaderText="Phone Number" />


but it's not displaying Gridview.plz give a suggestion how to solve it

Could not find specified column in results: member_id,card_id,name,paid_amount,due_amount,paid_date,location,phone_number]

if i keep ur code i got the error as above ,those r my database column names

gridview itself not displaying

yes , it's entering and executing complete code there is no errors.

code in transaction.aspx.cs get executed ,i observed that by keeping breakpoint. rdr(Data Reader)
is showing HasRows=true.but the gridview is not displaying

yes it's giving values from database by executing the query in workbench

thanq ,thanks a lot...

ok, i was removed and checked , but still not working.

no change click event is not firing

eventhough it's not working. by removing AutoPostBack

no i didn't get,

no i wasn't be missed adding validationgroup and validation message for any validator.

in edit panel am not using any validations

yes it's validation problem , bcoz by keeping CausesValidation="false" button click event in edit panel is fired.

how to solve it.

yes ,only in Add panel button click is firing.in other panels button click is not working . why it's not working. plz help me ,am struggling with it since two days.

thanks a lot

How to check whether the textboxes having data or not in javascript. how to get the value of textboxes(which are in ajaxtabcontrol toolkit tabs) in javascript

In the tab page code behind file, i have

protected void usertabContainer_ActiveTabChanged(object sender, EventArgs e)
{
string uname = Request.QueryString["UserName"];
String password = Request.QueryString["Password"];

if (usertabContainer.ActiveTabIndex == 2)
{
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
String query = "select member_id,card_id,name,date_of_membership,opening_balance,phone_number,address,password,confirm_password from admin where member_id='" + uname + "' ";
MySqlCommand command = new MySqlCommand(query, con);
con.Open();
using (MySqlDataReader rdr = command.ExecuteReader())
{
if (rdr.Read())
{
txtsettingmemid.Text = rdr["member_id"].ToString();
txtsettingcardid.Text = rdr["card_id"].ToString();
txtsettingname.Text = rdr["name"].ToString();
txtsettingdate.Text = rdr["date_of_membership"].ToString();
txtsettingopenbal.Text = rdr["opening_balance"].ToString();
txtsettingphone.Text = rdr["phone_number"].ToString();
txtsettingaddress.Text = rdr["address"].ToString();
txtsettingpwd.Text = rdr["password"].ToString();
txtsettingconfirmpwd.Text = rdr["confirm_password"].ToString();

}
}
}
}
}

when i click OK ,it's entering into this event(it's executing untill ) {
string uname = Request.QueryString["UserName"];
String password = Request.QueryString["Password"];

if (usertabContainer.ActiveTabIndex == 2)

but it's not tab=2, so moved to end and jumping into OK button fun.then moving to transaction , and executing completely. but it's not displaying Gridview

and i checked while debugging rdr (reader)---> HasRows=true

ok , i was checked it .but am not getting the issue

query is correct, already i was debugged the query by taking runtime values.
am not getting what is the problem.

after entering memberid,cardid,fromdate,todate ,when i hit OK it's redirecting to Transaction page.upto this fine, but Transaction web page should disply gridview, it's not displaying.

plz give me solution , how to solve it. am struggling a lot with this issue.

ichecked it , but i googled i requires membership...., but i don't know about that so am solving it by without using ChangePassword Control

still same problem, with out entering any data into textboxes ,if i click OK ,then popup is showing "do You want to delete."

if i doesn't enter any data , that should give a message as enter data for memberid or card id.

may be i need to write server side popup control instead of client side in button click,how to solve it.

if i write this, when i hit OK button it's not displaying popup.

ok, how can i get txtdmemid textbox value into javascript.
Help me am strugling a lot with this issue.

ok, but my textbox is in ajaxtabcontrol tab.

<ajax:TabPanel ID="tbpnldelete" runat="server" ><HeaderTemplate>

Delete Member

</HeaderTemplate>

<contenttemplate>



<asp:Panel ID="DeleteMem" runat="server" Width="476px">

<table align="center">
<tr>

<td></td>
<td align="right" ></td>


<td class="style1">Delete Member </td></tr>


<tr><td></td><td align="right">Member ID: </td><td class="style1">



<asp:TextBox ID="txtdmemid" runat="server" Height="21px" Width="112px"
>   </td> <td></td></tr>



<tr><td></td><td align="right">Card ID: </td><td class="style1">
<asp:TextBox ID="txtdcardid" runat="server"
>   </td></tr>


<tr><td></td><td align="right">



<asp:Button ID="btndok" runat="server" Text="OK" OnClick="btndok_Click" onclientclick="return DeleteItem()" />   </td>


<td class="style1">



<asp:Button ID="btndcancel" runat="server" Text="Cancel"
onclick="btndcancel_Click" OnClientClick="this.form.reset();return false;" />   </td></tr></table>









how to get the value of that textbox(txtdmemid)

<script language="javascript" type="text/javascript">
function ConfirmOnDelete(memberid,cardid) {
if (confirm("Are you SURE you want to Delete") == true) {
window.location = "del.aspx?memberid="<%=txtememid.Text%> "&cardid="<%=txtcardid.Text%>;
return true;
}


and button
<button id="btndok" value="Delete" önclick="ConfirmOnDelete('<%# Eval("memberid,cardid") %>')">
</button>

and in page load
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
String query = "delete from admin where member_id=@memid OR card_id=@card";
MySqlCommand command = new MySqlCommand(query, con);
command.Parameters.AddWithValue("@memid",txtdmemid.Text);
command.Parameters.AddWithValue("@card", txtdcardid.Text);
con.Open();
command.ExecuteNonQuery();

}//connection

please help me, can i write is there any wrong

<script language="javascript" type="text/javascript">
function ConfirmOnDelete(memberid/cardid) {
if (confirm("Are you SURE you want to Delete") == true) {
window.location = "del.aspx?memberid=" + txtdmemid.text + "&cardid=" +txtdcardid.text;
return true;
}
</script>

shall i write like this.


onclick="ConfirmOnDelete('<%# Eval("MobileNo") %>')"

here is Eval predefined fun or not.

ConfirmOnDelete('<%# Eval("MobileNo")

there u have taken only mobile no,but i need to pass either memberid or cardid .
if i any one that record should be deleted.

i don't have another page (del.aspx).i can enter either memberid or card id ,to delete.

<script type="text/javascript">
function DeleteItem() {
if (confirm("Are you sure you want to delete ...?")) {
return true;
}
return false;
}
</script>

thanks a lot it's working

thanks for ur responce, i was added scriptmanager

it's ok plz give an example how to use validation groups
for perticular button.

plz check out my code behind.

i wasn't used any validations for those tabs and their controls.

yes, exactly but i wrote code for click events,
when i click the button from design it's moving to proper click event ,but in debugging it's not perfoming,why am not getting it.
am struggling a lot since one week

means ,here is my code for admin page design


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Admin.aspx.cs" Inherits="Online_Billing_System.Admin" %>
<%@ Register Namespace="AjaxControlToolkit" Assembly="AjaxControlToolkit" tagPrefix="ajax" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Admin</title>
<script type="text/javascript">
function DeleteItem() {
if (confirm("Are you sure you want to delete ...?")) {
return true;
}
return false;
}
</script>

<style type="text/css">
.style1
{
width: 151px;
}
</style>

</head>
<body>
<form id="form1" runat="server">
<ajax:ToolkitScriptManager ID="scriptmanager1" runat="server">

<div style=" width:89%">
<ajax:TabContainer ID="adminTabContainer" runat="server" ActiveTabIndex="3">
<ajax:TabPanel ID="tbpnladd" runat="server" ><HeaderTemplate>Add Member</HeaderTemplate><contenttemplate>
<asp:Panel ID="AddMem" runat="server" Width="738px">
<table align="center"
style="width: 651px"><tr><td></td><td align="right" ></td><td align="center">Add Member </td></tr><tr><td></td><td align="right" >Member ID: </td><td><asp:TextBox ID="txtmemid" runat="server"></td><td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ErrorMessage=" Enter Member ID " ControlToValidate="txtmemid"
ForeColor="Red"></td></tr><tr><td></td><td align="right" >Card ID: </td><td><asp:TextBox ID="txtcardid" runat="server" ></td><td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ErrorMessage="Enter Card ID" ControlToValidate="txtcardid" ForeColor="Red"></td></tr><tr><td></td><td align="right">Name: </td><td><asp:TextBox ID="txtname" runat="server"></td><td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ErrorMessage="Enter Name" ControlToValidate="txtname" ForeColor="Red"></td></tr><tr><td></td><td align="right">Date Of Membership: </td><td>
<asp:TextBox ID="txtdate" runat="server"
> </td><td><ajax:CalendarExtender ID="calendar1"
TargetControlID="txtdate" runat="server" PopupButtonID="calendar"
Format="yyyy-MM-dd" Enabled="True"></td>

<td class="style1">
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ErrorMessage="Enter Date Of Membership" ControlToValidate="txtdate" ForeColor="Red"></td></tr><tr><td></td><td align="right">Opening Balance: </td><td><asp:TextBox ID="txtopenbal" runat="server"></td><td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ErrorMessage="Enter Opening Balance" ControlToValidate="txtopenbal" ForeColor="Red"></td></tr><tr><td></td><td align="right" >Phone No: </td><td><asp:TextBox ID="txtphone" runat="server"></td><td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ErrorMessage="Enter Phone No" ControlToValidate="txtphone" ForeColor="Red"></td></tr><tr><td></td><td align="right" >Address: </td><td align="left"><asp:TextBox ID="txtaddress" runat="server"></td><td>
<asp:RequiredFiel

am using ajaxcontroltoolkit

i was closed vs and again opened that project , it's displaying in design time ,but in design tabs are in vertical but i need in horizontal. in debugging it's showing properly.

how to remove and install.

i was added ajaxControlToolkit.dll in references and added declaration tag to register

except this shall i need to do any changes in system.web , if so how to do that

when am debugging it's working , but in design it's showing error,
what's the problem

am not getting intellitrace in vs 2010

i have deleted all breakpoints as u said, eventhough it's consuming so long time.

ok responce.redirect transfering but i want the values of login in Admin

how can i get those values

thanq, working by using responce.redirect.

just i heared server.transfer is the best method am very new to .net

thanq

ok thanq

simply how to get the parameter from user while installation.

not that thing,while installing the application using installer that should ask drive/folder.

in that folder ,from project ,we r creating excel sheet

ok thanq .

ok,my serialport_datareceived() is like this:
<pre lang="c#"> private void serialPort1_DataReceived(object sender, System.IO.Ports.SerialDataReceivedEventArgs e)
{


if (serialPort1.BytesToRead>0)
{
buffer = new byte[serialPort1.BytesToRead];
serialPort1.Read(buffer, 0, buffer.Length);
run.Set();
}
}</pre>

when i click button , from my application serialport writes data to device and creates a thread then executes downloadThread() method at run.waitone()it's wait for the event,when device returns data serialport_datareceived event will be fired after reading data at run.set() that thread will be invoked and executes remaining of downloadThread() method.

But here am getting error as:
NullReferenceException was caught: Object reference not set to an instance of an object.

in catch() of downloadThread() method


plz help

ok, but here run is an object of AutoResetEvent, and am using thread
downloadThread.

thanks for quick reply.
i searched google ,using abort is dagerous.keeping thread as background will terminate the tthread only when application is closed.But i want to teminate it when i complete reading from serialport.

hi,
by using above code. when i run it's giving first row , and it not receiving data(buffer is filled wilh 0x00) why am not getting.

ok, am also reading data(from $ to #) byte by byte and placing in byte[] buffer.then wakeup the thread to check the responce,

after reading complete, i have data as bytes in buffer.

in threadUpload() method converting into String, and spliting that string then i have responce in 2nd position (1).

then execute next record.

ok ,comment that line plz give me the solution

when i click upload button , thread should start, and send first record of excel.then immediatly another program through serialport sends responce for ex:am taking $M121,0#

then split that responce and test if it is 0(after ,) then only send next record.

so here am taking a thread in upload _click(), proces the first record and wait for responce, in serialport_datareceived() ,when it reads data (it should read complete data between $,#) then resume that suspended thread. this is my task plz help me......

am trying a lot

serial port receiving data from excel sheet. after every row imy appli need to send ok signal then only serialport read next row and send to application.

but my application reading all the rows at a time ,and placing in excel as

machid custid name totalBalance paid lastpaidDate remaining
m123 m123 m123 m123 ..........

so on like that ,every column(received data) is displaying in all excel columns ,

ny serialport_dartareceived is:
if (!serialPort1.IsOpen)
return;

Thread.Sleep(50);
byte[] buffer = new byte[serialPort1.BytesToRead];
serialPort1.Read(buffer, 0, buffer.Length);

s = System.Text.ASCIIEncoding.ASCII.GetString(buffer);
// MessageBox.Show(s);

plz help me how to store that data in excel

ok this exception was solved by starting columnindex 1.but data is not storing in excel.

ok thanq

Regex is in which namespace

data is coming from excel through serial port

hi,
thanq ,my string stars with $ and ends with #

in between them all the words based on delimeter , i need to split that string and at the same time need to place in excel sheet.

plz anybody help me.........

ok but i need in second thing . from 2nd application to 1st application . where can i write

ok working fine.

thanq soooooooooooo much for your quick reply........

i ran that by keeping that in a button.

first i debugged the two applications. then i clicked the button in which i placed that code .it's giving error as

invalidOperation exception was unhandled
Cross-thread operation not valid: Control 'textBox2' accessed from a thread other than the thread it was created on.

plz where can i keep that code and how to test plz help me. qm very new to serial port

just i need to test ,whether they are sending/receiving data .

in application1 ,i have serialport and it's port is COM5.
in application2 ,i have serialport and it's port is COM6.

am sending data from application1 that should be received in appl2 textbox.both applications are in different namespaces.

yes i read those but am not getting

in serialport1_datareceived( , ) i have a message ,but it's not showing.
actually here my concept is:

first i need to select excel file by clicking browse button then click on upload button it's going to serialport,after receiving data that needs to send ok signal back.

from: D;\ to c:\STL

i want to make copy o the file

private void Browse_Click(object sender, EventArgs e)
{
textBox1.Enabled = false;
OpenFileDialog fdlg = new OpenFileDialog();

if (fdlg.ShowDialog() == DialogResult.OK)
{
fdlg.Filter = "Excel Files|*.xls";

textBox1.Text = fdlg.FileName;
File.ReadAllText(textBox1.Text);
// string extension1 = Path.GetExtension(textBox1.Text);
//MessageBox.Show(extension1);
}
}

private void Saveas_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDialog1 = new SaveFileDialog();

if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{

saveFileDialog1.Filter = "Text Files|*.txt";

textBox2.Text = saveFileDialog1.FileName;
File.WriteAllText(textBox2.Text,"hi");
// string extension2 = Path.GetExtension(textBox2.Text);
// MessageBox.Show(extension2);
}
}

how to generate database script

plz i didn't get it clearly