M.Waqas Aslam

hello! use this code before this CrystalReportViewer1.ReportSource = cryRpt [CODE] With crConnectionInfo .ServerName = "YOUR SERVER NAME" .DatabaseName = "YOUR DATABASE NAME" .UserID = "YOUR DATABASE USERNAME" .Password = "YOUR DATABASE PASSWORD" End With [/CODE] i hope this will solve your prob :) Please if your prob is solved the …

yes you can do this , make a user module and when a user login in prog , he have to login with his id , then you can check which functions he can perform . Regards

well if you are using auto increment in your id then try max function to get the max id , or if your auto generated id is not a number then there are two options 1- use top clause and the 2nd option is to make a new field name …

hello ! try this , [CODE] 'here is a function Dim objRandom As New System.Random( _ CType(System.DateTime.Now.Ticks Mod System.Int32.MaxValue, Integer)) Public Function GetRandomNumber( _ Optional ByVal Low As Integer = 1, _ Optional ByVal High As Integer = 100) As Integer ' Returns a random number, ' between the optional …

hello ! basically i am working on .net , but now i want to learn java , is there any software like visual studio for .net .if yes then please can any one tell me or provide me any helpful link. Best Regards M.Waqas Aslam

is it your class assignment or homework ?

there are so many softwares which are used to make installation packages , but vs also has its own setup wizard , here is a link hope this will helps you and gives you an idea.[URL="http://www.techrepublic.com/blog/programming-and-development/adding-a-setup-wizard-to-vbnet-applications/516"]http://www.techrepublic.com/blog/programming-and-development/adding-a-setup-wizard-to-vbnet-applications/516[/URL] Best Regards

ok try this [CODE] 'place this code at the click event of your grid , but please make sure that the selection property is set to the full row select. txtid.text = datagridview.item("columnname/Index",datagridview.currentrow.index).value.tostring() 'if you give the column name then use "" if you want to give index then dont …

please can you show your query , so we can help you . and please check these links [URL="http://www.crystalkeen.com/articles/crystalreports/groupexpert.htm"]http://www.crystalkeen.com/articles/crystalreports/groupexpert.htm[/URL][URL="http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=4728"]http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=4728[/URL] Regards

i think in your booking application add sms and email modules to give alerts to the customers .

hello ! do you try dtpFromBill.Value.Date.tostring() instead of this dtpFromBill.Value.Date . Regards

please first provide your query which you are using in your report . then we can help you in a better way. with out knowing the reason nobody can provide a solution. Regards

hello ! when ever there is a situation like this then always use two or more then two condition for updating and deleting records. for example . you have many fields in grid , one of them is ID and 2nd one is Name , just do like this [CODE] …

use loop to insert your data in array , and then print then in textbox and manually use vbCrLf after printing each value , your data will be in your required format . Regards

hello ! you can perform your required function like this [CODE] dim myCon as new sqlconnection("connection string") dim cmd as new sqlcommand dim i as integer myCon.open() for i = 0 to datagrid1.rows.count -1 cmd.commandtext = "delete from table1 where RecID=@RecID" cmd.connection = myCon cmd.parameter.addwithvalue("@RecID",datagrid1.item(0,i).value) cmd.executenonquery() next myCon.close [/CODE] i …

hello ! you can use this code at the double click event of the listbox whose value you want to show. [CODE] Form2.ListBox1.Items.Add(ListBox1.SelectedItem.ToString) [/CODE] hope this code helps you , if yes then please vote me up :) Regards

hello ! please use this code this will solve your prob :) [CODE] Dim str As String Dim strArr() As String Dim count As Integer str = txtUsername.Text ' txtbox having txt you wana split. strArr = str.Split("_") For count = 0 To strArr.Length - 1 If txt1.Text = "" …

hello ! Yes,there is a way. Set KeyPreview property of your Form to True. And use this code for your Form_KeyDown event: [CODE] Private Sub Form1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyDown If e.KeyCode = Keys.Return Then SendKeys.Send("{TAB}") End If End Sub [/CODE] hope this helps you. …

yes this error is only occurs when you want to edit foreign key , for example , if there is two table having fields . Stuid , name and table 2 has fields id , stuid ,in this situation if you want to edit value of Stuid in table then …

alyngill is right , use above mentioned code , it will solve your prob . Regards

yes you can use binding navigator for this purpose.add same datasource you assign to grid to binding navigator.it will navigate your records. Regards

can you please explain your prob , so that i can help you

hello ! if you are using db with this application then make a table for example name tblLogingFail .now when ever you want to ban a user then insert data in that table fields name recID,UserID,Logindate , now after this set condition that if logintime difference is less then 10 …

hello ! here is an error [CODE] Case "Student ID" strsql = "{drop_student.Dropstud_no} = " & GUIREP_drop.search_student.Text.ToString & "" 'because student_id or student no is numeric vlaue , and you are using tostring . use this code Case "Student ID" strsql = "{drop_student.Dropstud_no} = " & val(GUIREP_drop.search_student.Text) [/CODE] Hope this …

hello ! can you please tell me , which reporting tool you are using ?

hello ! i am working on a single page of asp ,and i am using ext js 4.0 with it . i have a grid of extjs , my task is to show records in that grid from mssql server 2008 , for getting records i am using webservice . …

can you please explain what you want to do , if you have any prob regarding with sql then please post your question in sql forum . Regards

[QUOTE=networkmancer;1763840]Get this error [CODE]Conversion from string "INSERT INTO CAGETYPE(CAGECOST,"to type 'Integer' is not valid.[/CODE][/QUOTE] hello ! please try this code , [CODE]Dim sql As String = "INSERT INTO CAGETYPE (CAGECOST, CAGENAME) VALUES(" & val(roomprice) & ",'" & roomtitle & "')"[/CODE] hope this will solve your prob , if yes then …

yes u can do this , use selection formula , for this . Regards M.Waqas Aslam

well if you are getting this error then little bit change your code like this [CODE] mystr = "{tablename.EmployeeID} = " & val(textboxA.text) & " and {tablename.PayrollNumber} = " & val(textboxB.text) [/CODE] hope this will help you , and please post your code after getting some error so that any …

sorry but i cant get your point . please rephrase your question . Regards

hello ! check this out [CODE] 'first import these classes Imports System.Web Imports System.IO Imports System.Net.Mail Imports System.Net.Mail.Attachment Imports System.Runtime 'now use this code to send emails with attachments Sub mail() On Error Resume Next Dim mail As New MailMessage() Dim SmtpServer As New SmtpClient SmtpServer.Credentials = New Net.NetworkCredential("YourEmail ID", …

please check these links , may be they will help you [URL="http://www.codeproject.com/Articles/93357/Text-Box-for-Currency-in-VB-NET-2010"]http://www.codeproject.com/Articles/93357/Text-Box-for-Currency-in-VB-NET-2010[/URL][URL="http://forums.whirlpool.net.au/archive/599310"]http://forums.whirlpool.net.au/archive/599310[/URL] Regards

try this code :) [CODE] If ListBox1.Items.Count = 0 Then Else End If [/CODE]

hello ! you can do it like in this way [CODE] Dim total As Int32 Dim i As Integer For i = 0 To ListBox1.Items.Count - 1 total = total + Val(ListBox1.Items(i)) Next txttotal.Text = total [/CODE] hope this will solve you prob , if yes then vote me up …

hello ! you are getting records from db , and then want to search records from the grid ? can you please rephrase it

hello ! use this code [CODE] If MsgBox("r u sure ", MsgBoxStyle.YesNo) = MsgBoxResult.Yes Then 'your form closing code End If [/CODE] Hope this will help you ,if yes please vote me up :) Regards

surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 all these fields having same data ?

if you are using vb 6 then please post your question in vb 6 forum to get good solutions of your prob.

hello ! i think you want to show the related records of given code in textbox in combo and then if you change the value of combo then want to show the related code in textbox, am i right ?

hello ! if you want to insert data from vb.net form to your mssql database then this code will help you [CODE] dim mycon as new sqlconnection("connectionstring") mycon.open() dim cmd as new sqlcommand cmd.connection=mycon cmd.commandtext="insert into table (field1,field2) values (@field1,@field2)" cmd.parameters.addwithvalue("@field1",txtField1.text) cmd.parameters.addwithvalue("@field2",txtField2.text) cmd.executenonquery() mycon.close() [/CODE] Hope this will helps you …

hello ! i want to know if there is any programming language to develop desktop applications which can not be decomplie any way .as i am currently working in .net , and it is very easy to decompile .net code . is there is any other language which is safe …

hello ! here is an error in your code [CODE] cmd.Parameters.AddWithValue("@p1", FirstName)'---error cmd.Parameters.AddWithValue("@p2", LastName)'---error cmd.Parameters.AddWithValue("@p3", Address)'---error '================================================== 'check this code cmd.Parameters.AddWithValue("@p1", txtFirstName.text) cmd.Parameters.AddWithValue("@p2", txtLastName.text) cmd.Parameters.AddWithValue("@p3", txtAddress.text) [/CODE] Hope this will work fine :) if your prob is solved please mark this thread solved and vote me up :) Regards

if you want to update records of images in single table then use loop and if you want to update records of images in multiple tables then it is better to use stored procedures or if you dont know about stored procedure then use multiple update statements to update your …

hello ! i have no idea how to deal with ms access , but here is a code to insert image in mssql , may be this will give you any idea . [CODE] 'use this code where you are assigning the values in you command SqlParameter("@picture", SqlDbType.Image)).Value = arrimage) …

hello! you have to use group on author name ,now there are two possible ways to perform this action ,1-use crystal report groups for this (i not recommend it) and no 2nd is try to use view and in your view group on author name .you want to show your …

try some other reporting tools , like telerik is one of the best reporting tool now a days ,and you can get full support from here [URL="www.telerik.com"]www.telerik.com[/URL] Regards

hello ! please check this link may be it will solve your prob :) [URL="http://p2p.wrox.com/sql-language/12823-convert-null-string-concatenation.html"]http://p2p.wrox.com/sql-language/12823-convert-null-string-concatenation.html[/URL]

right click on your project in your solution window , then select ADD ---> Existing Item--->Browse and select your report then press ok . your report will include in your project ,or in order to add new report item then right click on your project in your solution window , …

Please explain your question .this is not the right way .:-|