Re: how to give value to parameter in a query of dataset in C#.net2005?
the query is for FillByCNPending is:SELECT ServiceID, ServiceDeliveredDate, CustomerName, FROM [Freedom Scooter Service Reminder]WHERE (CustomerName = '@CNAME')AND (ServiceDeliveredDate IS NULL)my code...
I developed an application using vb.net 2003, which contains crystal report, in the code, i gave the parameter values, so that when "report" button is clicked, the report automatically displays itself with given parameter values.however, i opened this application within vb.net 2005, and...
I have developed a simple application, my friend designed a startup flash animation (.swf file) for me, but i have no idea how to combine this file with my application so that it will appear every time when i run the exe file of my application.
plz help
hi i am new to mssql db stuff. I just developed my first VB.NET application and it uses a mssql database which is hosted locally on my development machine. I built the deployment msi file for my application which can be installed easily on client machine, but have no idea how to move the mssql...
here is the code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
If ModuleUser.frmCRCurTestDetails.SqlConnectionGetRptTitleValues.State = ConnectionState.Closed Then...
I use vb.net and MSsql.
1. In my report's "header" field, i want to display a details of the current user. (the user name is a unique key in db table and the current user name is held in my program: datamoduleUser.userName, i can code a dataset, dataadapter to select the details, just not suer...
"8/12/2005 11:05:01 PM" in db, but only "8/12/2005" appears in datagrid
i have a dabacolumn "startDate" that contains data in a format as : "8/12/2005 11:05:01 PM"
when i fill this table into a dataset and bind it with a datagrid, at run time the startDate column in datagrid only shows like...
"object instance not set to an instance of an object vb.net" happens when switch form
i have these 2 lines of code causing problem "object instance not set to an instance of an object vb.net" :
dim frm2 as new frm2
frm2.DsGetAllQs.Clear()...
I have code to show a form: frmAAA.show
I want to have some code to check whether a form is shown. that is, to figure out whether frmAAA.show is executed.
Can anyone help on code plz?
e.g. to check a connection, we can have: if not connection.state = connected. but there is no "state"...
how can i make a textbox only accept numeric value? (e.g. integer, double or decimal)? is it possible to do it in design view? or i have to code it? To validate numeric value in coding before pass the value to further process is a pain for me, can anyone help plz?
check out the code below
MsgBox(ModuleUser.frmUserRegistration.txtGender.Text)
'get gender field value for display
If ModuleUser.frmUserRegistration.txtGender.Text = UCase("m") Then
'check male radiobox when user is a male...
in MSSQL db, how can i keep the pk(e.g. userID) in a consistent sequence of number? sometimes it goes: 1, 2, 3, 4, 5, 100, 150, 235, 236. Is it possible to make it like: 1,2,3,4,5,6,7,8,9 ? plz help
does anyone know how to bold part of a message? e.g. for msg "thx for joining us, ABC", i want to bold "ABC", is it possible?also about changing color for part of the message, is it possible?plz help
hi experts, i want to program 2 messages while click on a button "submit". 1) when successful, i want to show a message with a tick symble on it and text saying "successful"2) when unsuccessful, i want to show a message with a cross symble on it and text saying "unsuccessful"can anyone help me...
[solved]problem updating db table after delete row(s) from dbgrid
I have a dbGrid that has databinding to a table RESULT in mssql db, i have these lines of code for removing selected record from table RESULT:
DsCompareResults.Tables("RESULT").Rows(Me.BindingContext(DsCompareResults...
[solved]get other columns from base on selected row in dbgrid
i have a dbgrid with databinding to mssql db table "RESULTS", the dbgrid displays all results that belong to currrent logged in user. the select sql is:
SELECT RESULT.STARTTIME, RESULT.ENDTIME, RESULT.TOTALMARKS, RESULT.GRADE
FROM...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.