hi dear i have desinged visual basic 2008 application , with back end sql server 2008 R 2 ,my project problem is saving data single table. details descriptions about my project. fields in database-table1 ------------------------- rdate-Datetimepicker1 noofoperations-textbox1.text
fields in databse-table 2 ----------------------------- rno- operationname operationnobatchno unitof measure noofworker inputcontainer noofcontainer grossweight outputcontainer noofcontainer grossweight netweight above second table data saving through datagridview. my requirement is first select date,then enter no of operations( for example 3 operations) so datagridview row create empty rows automatically base upon no of operations. then save. But i have designed two tables one is two fields store and another tables all fields ,dont i am beginner. please send me coding related saving data all fields combined i have attached images of all fields please reply.
actually i forget this.that is my problem is i cant web editing in visual studio....i know about web development .in past i used Dreamweaver software for developing a page.But when i used visual studio for front-end portion develop a page.just i forget this .if tell me how to do..any sugestion or tutorial website.????
I am trying to build a report onto my application using VS2005(Cannot afford to upgrade even though I want to). The idea is to load data from my database into a dataset Item (Named DS_RPT_AssetStructure.xsd) using the table "TBL_AS" inside the dataset. I then have a report viewer (RV_AssetStructure) that links to a report (RPT_AssetStructure.rdlc). Now, when I run the report, I get back the error "A datasource instances has not been supplied for the datasource 'DS_RPT_AssetStructure_TBL_AS'. I have tried just designing the report to link directly to the dataset, and repointing the Datasources, but nothing seems to work. I really need to get this to work. Please can someone assist me.
Here is my code that refreshes the report:
Dim Con AsNew SqlConnection(Startup.TB_Connect.Text)
Dim Cmd AsNew SqlCommand("EXEC sp_Rpt_AssetStructure " & SQL.SetVar(RCM.CB_Reports_AssetStructure_LocationID.Text), Con)
RCM.Cursor = Cursors.WaitCursor
Dim dsAS AsNew DS_RPT_AssetStructure
Dim rs = New DS_RPT_AssetStructure.TBL_ASDataTable
Dim da AsNew SqlDataAdapter("SELECT * FROM rpt_RCM_AssetStructure Order by [AltSeq]", Con)
Catch ex As Exception
MsgBox("Error Running Asset Structure Report." & vbCrLf & ex.Message)
RCM.RV_AssetStructure.LocalReport.ReportEmbeddedResource = "REW.RPT_AssetStructure.rdlc"
RCM.RV_AssetStructure.LocalReport.DataSources.Add(New ReportDataSource("AS", rs))
RCM.Cursor = Cursors.Arrow
The msgbox i have there, is to confirm that my dataset has data, and I can confirm, that I am getting a row count back.
Thanks for the concern Richard, but it is not. The purpose of the SQL.SetVar function turns the whole thing into a string make SQLi harder to do, and then to further prevent it, the code in the SP cannot handle SQLi, and will instead fail with an error msg. Also, the CM_Reports_AssetStructure_LocationID object is also defined as a style DropDownList, so the users are restricted to certain values.
I don't mean to sound rude and ungrateful, but I do appreciate your concern, but right now, I am more concerned about making the report work.
i have a gridview inside repeater that get its rows from db
i can fill both te repeater and the gridview
i need to edit the rows in gridview and submit the result to db
how could i do that pls provide a code
That's a bit extreme just to remove one application. I have added and removed many versions of Microsoft Express editions and never had a problem with the newly installed versions. I currently have C++ 2010, C# 2010 and Desktop 2013 installed and they all co-exist fine.
Last Visit: 31-Dec-99 19:00 Last Update: 26-Dec-14 17:04