Topics
-
- 7 replies
- 1.2k views
Hi I was wondering what is the most of effective way for storing pictures in a database. One option that I was considering was, simple save the picture to a folder on the localmachine and then add the path to that picture into the database field. Otherwise, would it be more effective to use the datatype image in the database table. Any other suggestions?? Mike55
Last reply by bri189a, -
- 2 replies
- 1k views
Hi I am writting an application that needs to connect to a sql server that is on the internet. http://www.yourmobileismymobile.com This server has the sql server and sql server port is open and i know the (username and password),the question is how do i set the connection string And i also know the database name in sql server Any ideas Thanks in advance
Last reply by bri189a, -
- 1 reply
- 903 views
Can any patterns gurus rip appart my attempt at encapsulating my data access layer. It's based on an abstract DataEntity superclass that abstracts its own Create, Retrieve, Update and Delete methods, all classes that utilise data from a db implement the DataEntity class. The DataEntity uses a DataManager which is a singleton responsible for making database calls. The Create method is overloaded to allow for 3 different implementations: 1 - no params Create() - creates a blank version to be added to the db 2 - an int param Create(int id) - calls for the row of information specific to the ID provided 3 - a DataRow param Create(DataRow dr) - no call to database creat…
Last reply by bri189a, -
- 10 replies
- 1.2k views
If I have two coordinates for a line, the begining and the end, how do I find what angle the line is pointing relative to the begining of the line? I need this for a upcoming project where I need to move the camera in a 2D world and it has to follow a line thus I need to know the angle which the camera needs to move at. Thanks!
Last reply by Joe Mamma, -
- 4 replies
- 1.3k views
Hi all, I am try to make something that can update my database from my combobox, since I have 10 comboboxes on my form, and each perform the same function and had the same data source. The scenario is that: 1. I have 2 tables that needed to update 2. I need to check whether the string that I typed on my combo box is existed on my database, if not, then add to the database. The problems come in when I am trying to check my combo box, I tried many method, and still not working. Can someone lead me with this? Thanks very much PlayKid Private Sub SupplierActivitesInformation() Dim drSupplierActivities As DataRow Dim c As Control …
Last reply by PlayKid, -
- 1 reply
- 752 views
Is there a problem with this setup? I am trying to use a value from one private Dataset to populate another private Dataset... Public Class Form1 Private Sub ListBox1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ListBox1.Click Dim frm2 As New Form2 frm2.Text = frm2.Text & " HNDL" & Convert.ToString(frm2.Handle) colForms.Add(frm2) frm2.Show() [b]frm2.stest = ListBox1.Text[/b] End Sub End Class public class Form2 [b]protected friend sTest as string[/b] end class or is it better to set up properties? public class form2 Private m_SQLparam As String Public WriteOnly Property SQLparam() …
Last reply by FZelle, -
-
- Administrators
- 2 replies
- 637 views
How do I remove this : from the end of a word Eaxmple Account: <----- this is how it appears in the string Dim strText As String = "Account:" Dim myVar As String myVar = ' Ok right here I should do a Trim function but I cant remember how Thank You in advance vbMarkO
Last reply by neodammer, -
-
- 2 replies
- 919 views
Okay, I finally got VS 2005 beta and installed it today. I created a Windows app, which was pretty similar to vs 2003. Now I went to the code window and tried to do my imports statements for data and oledb and there is nothing there. So how do you create a connection in this version. I am so confused now. :( Chester
Last reply by cpopham, -
-
- Leaders
- 5 replies
- 1.4k views
Hey guys, is there any other way to run a dos command than system.diagnostics.process.start("filename") for example i need to run a nslookup command and pass arguments to it like writting on CMD: nslookup blabla.com >> file.txt in the case of system.diagnostics.process.start("C:\windows\system32\nslookup.exe blabla.com >> file.txt") doesn't work ... any ideas ... or any ideas instead using nslookup to see if a domain exists and return the result to the application ? thanks
Last reply by manishkaushik, -
-
-
- Leaders
- 3 replies
- 1k views
I know of all the basic functions on string searching but I wonder can you reverse it and start from the end and work backwords? like instead of in the string "abcdefg" getting "abc" can you get "efg" starting from the back and counting backwards?
Last reply by Iceplug, -
-
- 0 replies
- 1.7k views
Dear all, I am attempting to do something interesting with the datagrid, when I click a specific row on the datagrid, it open a form and the information that was on that row transferred to the form that just opened. Is it possible to do that? I know that it is possible on VB 6, but how can I do it with VB.Net? Thanks PlayKid
Last reply by PlayKid, -
- 4 replies
- 1.2k views
I have a friend that is a car salesman, and he has a simple Excel file with information about all the cars he sold and people he sold them to... and he is suppose to check up with these people every 3 and 6 months, so he wants to know how to make a thing where every day when Excel starts, it checks through them, and shows a message saying something like "You sold 'this car' to 'this person' n months ago." How would he go about doing that? A little spoon feeding would be nice, because this is for him and I really don't wanna take a lot of time to figure it out... ;) Thanks
Last reply by rot13, -
- 0 replies
- 991 views
Anyone know how to re-use a DataGridTableStyle object? When I try to attach an object, which I already attached to a different DataGrid, I get the error message: "Unhandled Exception: System.ArgumentException: Cannot add a DataGridTableStyle already parented to another DataGrid." I've tried removing the TableStyle from the 1st DataGrid with Remove and RemoveAt. Neither one seem to make a difference. I tried setting the TableStyle object's DataGrid property to Nothing...doesn't work. How in the heck do you "un-parent" a DataGridTableStyle? :confused: Any ideas? Thanks in advance,
Last reply by tfowler, -
- 2 replies
- 1.9k views
Can anyone see why my bigCookie, "cookieMonster", is not being set?public void Page_Load (object sender, System.EventArgs e) { string strUserId = "jdoe"; string strName = "John Doe"; string strDate = DateTime.Now.ToString(); HttpCookie bigCookie = Request.Cookies["cookieMonster"]; if (IsPostBack) { // Page Loads for first time Label1.Text = "Is Postback"; } else { // User Clicked a button Label1.Text = "Is Not Postback"; } if (bigCookie == null) { Label2.Text = "bigCookie = null"; bigCookie = new HttpCookie("cookieMonster"); bigCookie.Values.Add("userId", strUserId); bigCookie.Values.Add("name", strName); bigCookie.Values.Add("lastVisit", strDate); bigCookie.Expires = …
Last reply by joe_pool_is, -
- 3 replies
- 824 views
I have a routine that references an item of type Object. The particular item implements the IComparable interface. In my routine, how do I call its CompareTo method?
Last reply by JEHMayo, -
- 2 replies
- 2.8k views
this code for a parameterized update query is giving me an error that i can't figure out what the problem is. my code: updateCommand1 = New OleDb.OleDbCommand("INSERT INTO Event_Nuclear (SS_Patient_ID, EventAge, Weight, Height, StudyType, EventDate,StudyNumber, PILocation, Indication) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", Me.OleDbConnection1) updateCommand1.Parameters.Add(New OleDb.OleDbParameter("PID", OleDb.OleDbType.Numeric, 10)) updateCommand1.Parameters.Add(New OleDb.OleDbParameter("EventAge", OleDb.OleDbType.Numeric, 3)) updateCommand1.Parameters.Add(New OleDb.OleDbParameter("Weight", OleDb.OleDbType.Numeric, 3)) upda…
Last reply by jalo, -
- 6 replies
- 1.2k views
DsPitem is the dataset which I manually bound at design time with the BindingSource Control. 'data access using OLEDB [b]Dim dc1 As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\chrism\Desktop\qs2.net test\db.mdb")[/b] Dim da1 As New OleDb.OleDbDataAdapter(sSQL, dc1) Dim dr1 As DataRow da1.Fill(DsPitem, "Pitem") ListBox1.Items.Clear() For Each dr1 In DsPitem.Tables("Pitem").Rows ListBox1.Items.Add(dr1("item")) Next 1. instead of creating the OLEDBCONNECTION object, how can i make reference to the Connection object I created when creating datasets in Dat…
Last reply by Joe Mamma, -
- 4 replies
- 965 views
I'm having trouble with some ntext data in a comments field in our database. It doesn't seem to matter how I get the data, it just displays "<long text>". How do I get the real text from this field??
Last reply by samsmithnz, -
-
- *Experts*
- 4 replies
- 899 views
Ok, I've hit a brick wall! I am doing the following actions: 1. Upload a .CSV file from client to server (done) 2. Copy data from .CSV file into temporary table SQL server 2000 database (done) 3. Copy data from temporary table into main table (Code written to do that) 4. Delete temporary table (code written to do that) 5. Delete uploaded .CSV file from server, and 6. Inform user that the process is complete. I am using a stored procedure to carry out step 2. In its current form everything is working out correctly. I need to modify step 2 inorder to handle multiple simultaneous uploads. My solution was to create a temporary table for each user uploadin…
Last reply by Afraits, -
-
- 3 replies
- 1k views
Hi to all, I have a DataSet which i populate it with all the information that exists in a table in my database. I will bind that DataSet to a DataGrid to show the information but i don't what to show all columns that exists in the DataSet. So how can i limit what appears in the datagrid?? do i have to make a new DataSet with only the information i want? thx to all
Last reply by rfazendeiro,
-
Who's Online 0 Members, 0 Anonymous, 41 Guests (See full list)
- There are no registered users currently online