|
Asalam-O-Alikum!
what is the easiest way to insert data from one DataBase table to an other database table with same structure or same schema.
Reagards.
BasharatAli
Internee
METESYS Lahore
Pakistan
|
|
|
|
|
find info about DTS (Data Transformation Service) about the DBMS you are using. It is not difficult
Salman Sheikh
|
|
|
|
|
Thx for ur time
but i want to do this throug vb code at run time when user press a button.
Regards
BasharatAli
Internee
METESYS Lahore
Pakistan
|
|
|
|
|
I need to run a DOS process application and get the final ErrorLevel.
Three questions:
a) How can i execute from Vb.net
a) How can i get the final ErrorLevel.
b) Is possible to redirect output stream data process to a form on my applicacion.
regards
|
|
|
|
|
Hi,
have a look at the Process class.
You will be interested in the Start() method, the ExitCode property, and others as well.
And there are plenty of examples here on CodeProject.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
hai,
I have tried to use 3 layers
Presentation Layer,business Logic Layer, Data Access Layer
Just i Have tried,tell whether this is correct or not?
In My Presentation Layer[tUserPL.aspx]
i have two textbox one for UserName and other for password
<code>
Dim i As String
Dim UserBLL As New UserBLL
Private Sub btnSubmit_ServerClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.ServerClick
Try
UserBLL.User_Name = Me.txtuser.Value
UserBLL.User_Pass = Me.txtPass.Value
i = UserBLL.Verify()
If i > 1 Then
Response.Redirect("\IPB\tBillCorrectionA.aspx")
Else
Response.Write("Not an Authorized User")
End If
Catch ex As Exception
Response.Write(ex.Message.ToString())
End Try
End Sub
</code>
In My business Logic Layer[UserBLL.aspx] i Have the Following,
<code>
Public Class UserBLL
Public err, cmd_value, qry_value As String
Dim UserData As New UserDAL
Dim sqlconn As New SqlClient.SqlConnection
Public Property User_Name() As String
Get
Return cmd_value
End Get
Set(ByVal Value As String)
cmd_value = Value
End Set
End Property
Public Property User_Pass() As String
Get
Return qry_value
End Get
Set(ByVal Value As String)
qry_value = Value
End Set
End Property
Public Function Verify()
Dim sqlcmd As SqlClient.SqlCommand
Dim i As Integer
Me.sqlconn.ConnectionString = ConfigurationSettings.AppSettings("BB_CONSTR")
Me.sqlconn.Open()
Return UserData.ExecuteMsgQuery("select count(*) from mast_users where cLogin like '" & User_Name & "' and cPassword like '" & User_Pass & "'", sqlconn)
End Function
End Class
</code>
In My Data Access Layer[UserDAL.aspx] i Have following
<code>
Public Class UserDAL
Public Shared Function ExecuteMsgQuery(ByVal selQuery As String, ByVal myCon As SqlClient.SqlConnection) As Int16
Try
Dim SqlAdpt As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter(selQuery, myCon)
If SqlAdpt.SelectCommand.ExecuteScalar > 0 Then
Return 2
Else
Return 1
End If
Catch ex As Exception
Return 3
Finally
End Try
End Function
</code>
In above i have tried to get a concept but i think i am not in correct way and
i need a result like verfying the user name and password and return back to BLL
i am not getting any error and i am redirecting to another page after verifying user name and password. after i am getting correct as result i need to proceed the same concept in my project. help me out...
sathimailin
|
|
|
|
|
hi , i have a Written a nice for Beginners.
http://www.codeproject.com/useritems/N-Tier_Application.asp[^]
Hope it helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
for ex,
there are 2 datetimepicker,1 textbox,1 button named as firstdatetimepicker,seconddatetimepicker,noofdaystextbox and okbutton.
calculation is
seconddatetimepicker = firstdatetimepicker + noofdaystextbox.
example-1
if i give date to firstdatetimepicker is "22-10-2007" and i give no of days to noofdaystextbox is 4,then i click ok button means,must add 4 days from "22-10-2007",in seconddatetimepicker must automatically displayed as "26-10-2007"
example-2
if i give date to firstdatetimepicker is "15-10-2007" and i give no of days to noofdaystextbox is 9,then i click ok button means,in seconddatetimepicker must automatically displayed as "24-10-2007"
i do my project in .net 2005 windows application.i want in .net windows application.
|
|
|
|
|
It's very simple. Convert the string in the textbox to a number (for example using Int32.TryParse), then use the AddDays method on the date to create a new date with the days added.
---
single minded; short sighted; long gone;
|
|
|
|
|
datetimepicker.value is a property which returns or accepts date object
you can add days in a date using Date.Add method which will return another date with added number of days.
Salman Sheikh
|
|
|
|
|
how to save a windows application project in vb.net will be save as an .exe file as in vb6
|
|
|
|
|
in .NET you Deploy your Program in , and convert it into something we call" Msil", that will be your Exe. that Msil run on a .NET Platform, this means you have to install .NET framework where ever you run a Msil. So in your case now, Add a new Project and Add it to the Existing Project, choose Setup and Deployment Object and follow the Folling Guideline in on this site.
http://www.c-sharpcorner.com/UploadFile/vishnuprasad2005/SetupProjects12022005022406AM/SetupProjects.aspx[^]
Hope it helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
It's done automatically every time you run your app from inside the IDE. Look in your project folder. You'll find a bin folder with two folders inside it, Debug and Release. You're .EXE will be found in either of those folders.
The Debug version has all kinds of debug code compiled into it. You normally don't deploy this version to the customer. You normally deploy the Release version.
|
|
|
|
|
How can I track the keypress of Tab Key in a DataGridView. The column in which I want to track is of a textbox type column.
Your suggestions will help me a lot.
CSS.
Sekhar
|
|
|
|
|
What do you mean by "tracking a TextBox column"?? What do you want to do when the user hits the Tab key??
|
|
|
|
|
use keydown or keyup event and check
e.keydata = keys.tab
Salman Sheikh
|
|
|
|
|
I have a TabControl and several pages to it. Each of the pages contains one datagridview and few buttons. I want when i press the tab key on the last cell of the last row of a datagridview, it should take me to the next page of the Tabcontrol and place the focus on the first cell of the datagridview of that page. So for this I need to track the keypress for the cell from which i want to shift the focus to the next page's datagridview. And the last column of the datagridview is a textBox type column.
Sekhar
|
|
|
|
|
In that case, you handle the KeyDown event of the DGV and check the event args KeyCode property for the Keys.Tab key. If pressed, you have to check to see what the cuurnet cell is. If the current cell is the last one, you set the Handled propery of the event args to True and make your changes to the TabControl. Otherise, you do nothing.
|
|
|
|
|
I'm having a problem getting a textbox to display some data. The application is recording sound and I wanted to see a few pieces of data as it comes in. I set the text property from within a thread and it doesn't do anything, not even display a zero.
I've checked as the obvious stuff; the textbox1.text code is being executed, and there isn't any other code relating to textboxes anywhere else that would overwrite it. Any help would be appreciated
|
|
|
|
|
I'm surprised it doesn't blow up. In VB2005, accessing a form control from a thread that didn't create it, should blow it up.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
So what should I do to get around this problem? Does it apply to other controls to?
|
|
|
|
|
It applies to every control. You cannot modify a control from a thread other than the one that created the control.
Christian is correct, this should have exploded when the code got to updating the control. This tells me that either you've set that nasty little property called "CheckForIllegalCrossThreadCalls" to False, or you're wrapped the code that updates the checkbox in a Try/Catch block that's eating the exception that gets thrown.
You have to provide a method on your form to update the TextBox, create a delegate for it, then you Invoke that method to update the TextBox. From memory, it goes something like this:
Public Class Form1
Private Delegate Sub UpdateTextBoxDelegate(ByVal message As String)
Public Sub UpdateTextBox(ByVal message As String)
If TextBox1.InvokeRequired Then
TextBox1.Invoke(New UpdateTextBoxDelegate(AddressOf UpdateTextBox), New Object() {message})
Else
TextBox1.Text = message
End If
End Sub
This sub can be called from from code on the form running from any thread and the call will get marshaled back to the UI thread to update the textbox. All you have to do is call the sub:
UpdateTextBox("Some string...")
|
|
|
|
|
Hi all,
I want to know is there some way to execute a report from SQL Server 2005 Report Service? Honestly., i'm not really familiar with VB..in VS.Net I can execute the report using reportviewer control, but I can't find any similar control in VB6 form.
So please., if any of you can show me how to do it(if it is possible)..I'll realy appreciate it guys
|
|
|
|
|
Why go back to VB6, Microsoft have giveup on it.
Stick to .NET or you will have Problems, just look at vb6 and look at SQL 2005, do you think they can be friends?
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Actualy I'm personally prefer to use .Net to use SSRS for new application but in this case I have several application that already running on VB6 and I wondering if those applications can use SSRS as Reporting media.
So if there any information about it..please inform to us. Thanks ..
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
