Comments by Jawad Ahmed Tanoli (Top 96 by date)

you debug it ? same problem your facing it is not appending new data in dataModel right?

you should try like this
DateTimePicker seancepicker = new DateTimePicker();

DGVabsence.Rows[0].Cells[k].Value = seancepicker.Value;

if you want to display Group by Title
you can't put Group by in this table.title may be same but other fields are different you get every time all rows to show .

what error it display you

in your table id is unique
List<pic> sb = (from x in myEnt.Pic where x.ID == id select x).ToList();
it will return you one row .so put title in where x.title=="flower"

you Welcome

you try to debug the code ? try to check Records in DataTable dt? and and also check SessionHelper.User.ID value

try like this
Response.Redirect("~/RM/Admin/Offer.aspx")

what is your Query result? i think result is same as you required

Thanks for reply i remove manually MemoryManagement class and test it again .

Check in your spam

check your Dataset how many tables load in it.

which line is generating error?
int value = Convert.ToInt32(score); may be there have you try debug what is in score string?

insert into db1.dbo.country
Do not include auto generate column if you want your table to create it for your self
Select ColumnB,ColumnC,,,,,,,,,,,, from db2.dbo.country

autogenerate key is in both tables ? you want to keep the db2 country table same id in db1 country table or not ?

show some code

question is not clear what you want to do on tabPage click want to get text of tabpage?

select * from (select Cars.Car_id,convert(varchar, Change_date,101) as Change_date , Service_Type.Servce_desc, Current_dist,Prev_distance as Prev_dist,(Current_dist - Prev_distance) as Change_dist,value_Tashhem as Value,NULL as [Qty] from Tashhem s1 inner join cars on s1.Car_id= Cars.Car_id inner join Service_Type on s1.Servce_id = Service_Type.Servce_id where s1.Car_id = 555 and s1.Change_date between 1-1-2000 and 1-1-2016
union
select Cars.Car_id,convert(varchar, Change_date,101) as Change_date, Service_Type.Servce_desc,Current_Dist as Current_dist,Prev_Dist as Prev_dist,(Current_dist - Prev_Dist) as Change_dist,Value_Oil as Value,QTY as Qty from Change_Oil s1 inner join cars on s1.Car_id= Cars.Car_id inner join Service_Type on s1.Servce_id = Service_Type.Servce_id where s1.Car_id =555 and s1.Change_date between 1-1-2000 and 1-1-2016
union
select Cars.Car_id,convert(varchar, Change_Date,101) as Change_date, Service_Type.Servce_desc,Current_dist ,Prev_dist ,(Current_dist - Prev_dist) as Change_dist,Value_Fuel as Value,Qty from Full_Fuel s1 inner join cars on s1.Car_id= Cars.Car_id inner join Service_Type on s1.Servce_id = Service_Type.Servce_id where s1.Car_id =555 and s1.Change_date between 1-1-2000 and 1-1-2016
union
select Cars.Car_id,convert(varchar, Change_date,101) as Change_date, Service_Type.Servce_desc,Current_dist ,Prev_dist ,(convert(float,Current_dist) - convert(float,Prev_dist)) as Change_dist,value_tire as Value,NULL as [Qty] from Change_Tire s1 inner join cars on s1.Car_id= Cars.Car_id inner join Service_Type on s1.Servce_id = Service_Type.Servce_id where s1.Car_id =555 and s1.Change_date between 1-1-2000 and 1-1-2016
union
select Cars.Car_id,convert(varchar, Change_Date,101) as Change_date, Service_Type.Servce_desc,Current_dist ,Prev_dist ,(convert(float,Current_dist) - convert(float,Prev_dist)) as Change_dist,Value_Batteries as Value,NULL as [Qty] from Change_Batteries s1 inner join cars on s1.Car_id= Cars.Car_id inner join Service_Type on s1.Servce_id = Service_Type.Servce_id where s1.Car_id =555 and s1.Change_date between 1-1-2000 and 1-1-2016
union
select Auto_Parts.Car_id,convert(varchar, Auto_Parts.Change_date,101) as Change_date,Service_Type.Servce_desc,Auto_Parts.Current_dist,Auto_Parts.Prev_dist,(convert(float,Current_dist) - convert(float,Prev_dist)) as Change_dist,(s1.Value_Part) as Value,NULL as [Qty] from Auto_Part_Details s1 inner join Auto_Parts on s1.Job_Card = Auto_Parts.Job_Card inner join Service_Type on Auto_Parts.Servce_id = Service_Type.Servce_id where Auto_Parts.Car_id = 555 and Auto_Parts.Change_date between 1-1-2000 and 1-1-2016) as t order by t.Change_date

there is no union in your query
try
order by convert(varchar, Auto_Parts.Change_date,101)

you can do in query ?where is problem

Get html from db and assign like control.innerHTML ='your html' on client side

can i see your project over team viewer?

Yes the response which you received on button click this response is not correct format of html you can check
alert(response); while in code where your creating table you have to return response.write(html);

it means there is no postback try to check your response html is it in correct format or try this line and see it also disappear or not
$('#container').html('<p> Your record successfully saved</p>');

try to put same function in document.ready to load html again or check with alert weather it is reloading or not?

url: "CS.aspx/SaveUser" is this in another page returning html or on same page? because mostly happens due to page reload

is page do post back on button click ?

what is datatype of DOB in database ?

Thanks for reply :)

no just want to know weather this process can be done through c# or not.As we all know SQL INSERT QUERY can be written in different ways like EXEC('YOUR QUERY') etc.

it is just an example there may be number of queries with different table name columns name and values.the result may be number of columns and there values does not matter including comma or not

you must define your datatable with datatype like this

DataTable workTable = new DataTable("Customers");

DataColumn workCol = workTable.Columns.Add("CustID", typeof(Int32));
workCol.AllowDBNull = false;
workCol.Unique = true;

workTable.Columns.Add("CustLName", typeof(String));
workTable.Columns.Add("CustFName", typeof(String));
workTable.Columns.Add("Purchases", typeof(Double));

it means your DialledDuration is string datatype how many columns in your datatable

ok i will remove old solution thanks for suggestion

check my new solution

Share your query

is it windows form or asp.net application?

What is resultSet? how many columns in your datatable.
DataTable dt=new DataTable();
dt.Columns.Add("FName");
dt.Rows.Add(new object[] {"xyz" });

you can use Array.Copy Method

can you share your error during conversion and code

so where is problem ? if it remind you after some time

Where you want to add space?

Thank you very much :) now i have a way to go on :P but if any one of field is missing like Referer or host then it will not work .any how in my case all fields must be there :)

no it may be come any where in string but each field must contains char(13) new line at the end.

yes like host, Referer, Origin etc

Great Work Alex :) actually due to requirement change we used to get data from website using webbrowser by putting a button on webbrowser control when the user fill all form press the button and get all data to store in to database and for further process this project still running good.
which may be like this string visakind= webBrowser1.Document.GetElementById("VisaKind").GetAttribute("value");

Regex.Replace(System.Text.Encoding.ASCII.GetString(mystring, @"[^0-9a-zA-Z]+", ".");
i am using this but it will replace all characters i want that some character will not be removed

so if choose text files to store data then how should i determine the queries to retrieve data .

the application capture protocols over the server and the table consist of CaptureTime,SourceHwAddress ,DestinationHwAddress,IPType,SourceAddress,DestinationAddress,protocol ,SourcePort ,DestinationPort,ProtocolReadAbleData.

I am doing in this way to read..
foreach (var Xval in list1){
String DrugName= Xval.Elements("{https://secure.newcropaccounts.com/V7/webservices}DrugName").Nodes().Single().ToString();
}

Thanks for briefly reply :)
now what is the best way to read from list1 all nodes ..

it return nothing

what is root ?
this xml is in string variable.do i need to convert it into some other data type like xml?

then it will be hard to parse because there must be something unique if you will try to read alphabet only then also make some complex because it includes some other words.try to save multiple message string then observe what is common in all and where you get your desired message in string then it is possible to read accurately.

so your string pattern can be change every time ?
what did you know that will be common in your message?

there is a another node rowcount which will tell how many tags of <PatientDrugDetail>

yes it will be like this <patientDrugDetail> <PatientDrugDetail>some data tags</patientDrugDetail><PatientDrugDetail>some data tags</patientDrugDetail> </patientDrugDetail>

get selected row data from Grid then send it to your delete store procedure First Insert it into your history table then delete it.

hi what you want to do is that when student register his/her self and select multiple subjects you want to save selected subjects with student record?

read this hope it helps you
http://dev.mysql.com/doc/refman/5.1/en/load-data.html

you must provide where file is located like
'c:/worldcitiespop.txt'

Provide your full file path.

if you declare datatable inside button event you will have access to that variable inside that event.if you define it globally you will have access to it in all other events.

Chill60 i just want to post that piece of code.

try these links you can google your self you will easily find and learn.
http://www.codeproject.com/Questions/690560/How-to-store-and-retrieve-images-in-Microsoft-SQL
http://www.dotnetlogix.com/Article/aspnet/194/Save-and-retrieve-image-to-and-from-database-in-aspnet.html

try this
AssignmentGrid.Rows[AssignmentGrid.SelectedIndex].visible=false;

post your code how you bind gridview is it in page load event have you put !postback

is there any error ? or exception

Thanks it help me very much to get start ...

ASCII can not be converted to some other format to make it easy :)

yeah i know it can be any thing but what is this how i can read it??

if you have any idea then kindly help me :) where to start and how start with this to make a readable form :)

i want to make it readable to store in database it is a machine genrated code

to check
set allow null for RoomNo in table may be there is no value of RoomNo in Query.

Befor inserting into sql table check through debug what is the value of Room No in Query..

how your loading data from excel to gridview?and what other action your doing on gridview before sending to database just want to check the two cell values to check wether exsist in database table?

is it hudge amount of data in gridiew???

if the datasource is a datatable you can search in that like dt.select("sno='1'") if record exsist then select grid row or clear previous data in grid and assign new datatasource from exsistg datatable..may be helpful

use order by misc_date in your query

No it is not working i already do this it work fine without applying jquery.

you are right my problem was occuring due to missing of sp1 3.5 for campact edition when i install it it work perfect..

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at System.Data.SqlServerCe.NativeMethods.GetKeyInfo(IntPtr pTx, String pwszBaseTable, IntPtr prgDbKeyInfo, Int32 cDbKeyInfo, IntPtr pError)
at System.Data.SqlServerCe.SqlCeDataReader.FillMetaData(SqlCeCommand command)
at System.Data.SqlServerCe.SqlCeCommand.InitializeDataReader(SqlCeDataReader reader, Int32 resultType)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at SalePurchase.dataBase.GetDataTable(String Query)
at SalePurchase.PurchaserEdit.button1_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
SalePurchase
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///D:/Program%20Files/Default%20Company%20Name/SalePurchaseSetup/SalePurchase.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Data.SqlServerCe
Assembly Version: 3.5.0.0
Win32 Version: 3.5.5386.0
CodeBase: file:///D:/Program%20Files/Default%20Company%20Name/SalePurchaseSetup/System.Data.SqlServerCe.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version:

----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitdebugging="true">


When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

go on buddy and search it if you find some solution then also post here i am dying for this solution and suffering from 7 days..

no it does not work.
the strange thing is that when i install this setup on some other pc just have vs 2008 it does not generate any error work fine.Is there any thing which i have to install on Pc?
but when i install it on client pc which have only .netframework3.5 it only performed insertion and retrieve data from same this method to fill auto complete but it will not work for comboboxes and datagrid.
i am stuck there no idea if i am calling unmanged functions from manged code then it should genrate eroor when i am debugging ...
ok i am now trying to use Visual Studio RemoteDebugger on client pc and see what happend..

DataTable GetDataTable(string Query)
i also used this method to fill autocompletecollectionstring it also work fine there.
but it will not working to display data in combobox datagrid...
every thing is working fine on my pc also i run setup on pc there is no error when i try it on client pc it produce error only insertion and autocompletecollectionstring is working there.
i try it on some other computers result is same...

this is the part that generate error which i use to display the data.
public DataTable GetDataTable(string Query)
{
try
{
coon.Open();
DataTable dt = new DataTable();
cmd = new SqlCeCommand();
cmd.CommandText = Query;
ad = new SqlCeDataAdapter(Query,coon);
ad.Fill(dt);

return dt;

}
catch (Exception ex)
{
throw ex;
}
finally
{
coon.Close();

}

}

//Here is a class that i used for store and retrive data from db
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlServerCe;
using System.Data;
using System.Windows.Forms;
using System.IO;
namespace SalePurchase
{
class dataBase
{

private SqlCeDataAdapter ad;
private SqlCeCommand cmd;

private string StringdbFileName=("Data Source=" + System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\sp.sdf").Replace(@"file:\", "");
private SqlCeConnection coon;
public dataBase()
{


coon = new SqlCeConnection(StringdbFileName);

coon.Close();

}
public int ExecuteSQL(string Query)
{
try
{
coon.Open();
cmd = new SqlCeCommand();
cmd.Connection = this.coon;
cmd.CommandText = Query;
return cmd.ExecuteNonQuery();

}
catch (Exception ex)
{
throw ex;
}
finally
{
coon.Close();

}

}
public DataTable GetDataTable(string Query)
{
try
{

//if (coon.State == ConnectionState.Closed)
//{
// coon.Open();
//}
coon.Open();
DataTable dt = new DataTable();
cmd = new SqlCeCommand();
cmd.CommandText = Query;
ad = new SqlCeDataAdapter(Query,coon);
ad.Fill(dt);

return dt;

}
catch (Exception ex)
{
throw ex;
}
finally
{
coon.Close();

}

}

public void FillComboBox(string Query, string DisplayMember,string ValueMember, ComboBox cmb)
{
try
{
coon.Open();

DataTable dt = new DataTable();
cmd = new SqlCeCommand();
cmd.CommandText = Query;
ad = new SqlCeDataAdapter(Query, coon);
ad.Fill(dt);

cmb.DataSource = dt;
cmb.DisplayMember = DisplayMember;
cmb.ValueMember = ValueMember;

}
catch (Exception ex)
{
throw ex;
}
finally
{
coon.Close();

}
}
}
}