Comments by veenusethi (Top 52 by date)

Thanks and I already done this way before seeing it

Thanks Sir I solved Myself Thanks For help

yes Sir

You know sir i am in very strange situation i dont know how i come out. That is i make a split database ms access mdb file and i place it in Documents folder because of this file my setup is runing very well with no Problem. But when i delete or move this file into D:/ Drive or E: Drive then Error occur again. Please help me have you any video or article with screenshots of c# setup with access database and where database should be locate

You mean In program files/ data/mdb file then i should give permissions of r/w to mdb file or give to folder permisiions which is under in program files

Unhandled exception has occured in your application. If you click Continue.the application will ignore this error and attemt to continue.
Operation must use an updateable query
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.OleDb.OleDbException (0x80004005): Operation must use an updateable query.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.ExecuteReader()
at mahavir1.patientadd.button3_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: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
mahavir1
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Default%20Company%20Name/Setup1/mahavir1.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.

Yes Sir I place data folder inside bin/debug folder where exe file is exist.But no wins. When i create setup then i make folder data and place mdb file inside data folder. but i dont know why it does not pick path

i cant understand mr garaber what you said I am sorry Please Explain

nobody here for helping me

You can choose gridview, repeater etc

Or you can use also this if only one date is available

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:hospital %>"
SelectCommand="SELECT [Cr_No], [Cr_Dt] FROM [opdreport] WHERE ([Cr_Dt] = @fromdate )" >
<SelectParameters>
<asp:ControlParameter Name="fromdate" ControlID="txtdate" PropertyName="Text" Type="DateTime" />

</SelectParameters>

try to use sessions and pass them from form1 to form2

i already checked that link in that link and operator is used which is perfect but or operator is not working

I cant understand why this problem occur

yes i open this in firefox

when i off custom error then this error is occured

Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive.

I write this code and then upload web config file then it is showing default page blank

For subjects heading You should choose report header

you can use it use as clause.

Please Explain Your Question clearly?

are u installed apache server too?
may be port is distributed both of them apache and iis thats why problem can be occur
you should explain your problem accuartely.

please show your code

ya you should use sessions and using sessions you should pass unique id and then all values are also will pass in popup window

please improve your question explain clearly

Firstly you should change datatype in data table and then update database in crystal report and then try again

i have a dynamic gridview. here items are inserted by users . Gridview is not binded with database

for ex. i have three coumns
in 1) column item,
2) qty,
3) amount
1) in first column items here is combobox user will select item from here
2) in second column textbox exist here user will insert quantity value
3) In third user will enter amount
So i want user selct or enter item in first column without duplicasy one item should be select one time

Thank You sir i posted it i am new here so in solution if any mistake then i am sorry

Thanks Mits for trying to solve my problem. but now i solved myself

hdcompany is a hiddenfield and their value is coming using sessions

and yes i got companyname from saleitemass.companyname='"+hdcompany.value+"'

In query analyzer i got result here is no any issue

it is a code which i used
string query = " select saleitemadd.item,saleitemadd.date1,saleitemadd.party, saleitemadd.vch, companymaster.address from saleitemadd INNER JOIN companymaster ON saleitemadd.companyname=companymaster.companyname where (saleitemadd.companyname='"+hdcompany.Value +"')";
con = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(query, con);
com.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(com);
da.Fill(ds);
rptDoc.Load(Server.MapPath("saleitembillreport.rpt"));
rptDoc.SetDataSource(ds);

do you want bind dropdownlist with sql?
if yes simply click on arrow of dropdownlist in right hand and select your database and table from where city name will come.
and on textbox you can use like
textbox.text=dropdownlist1.selecteditem.text on any event

yes i did but nothing happened.
crystalreport do not show data . no any error

please improve your question

please explain your question in detail

i used join query but in crystal report nothing display.
in this line table name in "" is complusory or not
da.Fill(ds,"saleitemadd");
rptDoc.SetDataSource(ds.Tables["saleitemadd"]);// here ds.tables[""] is complusory or not reply me please sir.

and by the way thanks for ur reply

I want to use two datatables like this

string query = " select saleitemadd.*,companymaster.address etc... wherecompanyname='"+HiddenField1.Value +"'";
con = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(query, con);
com.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(com);
da.Fill(ds,"saleitemadd");
rptDoc.Load(Server.MapPath("salereport.rpt"));
rptDoc.SetDataSource(ds.Tables["saleitemadd"]);// but here problem is occur ?

i don't know how take two or more than two datatable from one?
companymaster and saleitemad tables have a pk-fk relation.
please help me how to show crystal report using more than datarables?

saleitemadd and companymaster are tableadapters

i am also suffering from this problem

But how to bind app_data folder's database with crystal reports

Thanks for your reply it works

ya you should check the path of image

No sir, in combobox itemname is a unique. i dont want any duplicasy in dynamic gridview ? if user select item name for first time i do not want user select that item again in gridview?

what type of data do you want to transfer?

Mainly i want to prevent duplicate selection from combobox in gridview itemtemplate which is first column of gridview? how i can check already selection has done from combobox