I am trying to create a console application that does the following:
1) read a text file
2) Save the content over to a SQL Server database
3) Use command line arguments to allow user to specify any delimited file
I am trying to create a console application that does the following:
1) read a text file
2) Save the content over to a SQL Server database
3) Use command line arguments to allow user to specify any delimited file
I'm creating an small application where I search from the databse table tems and add the result line to a datarow of my datatable "dt", I the set the datagridviewe datatsource to this same dt.How can I save this dt content into another table of the same database.I'm not ussing stored procedures and dont understand much of parameters.
CODE
Dim cs As New SqlConnection("Data Source=myserver;Initial Catalog=mydatabase;Integrated Security=True")
Dim da As New SqlDataAdapter
Dim ds As New DataSet("Chosed")
[code]....
How to save DataGridView content into a database?
View 10 RepliesI am trying to create an application, which in first phase will read the content of an XML file, count the products, and copy the content of the XML to a sql server database TEMP table, which i have already created. I have already created the code to read the content of the XML file and view it in a datagrid view. But i dont know how i should copy the content to the database i have created....
The code i wrote till now:
Imports System
Imports System.Xml
Public Class FrmXMLRead
[code]....
I need to copy each product (code, category, subcategory, part_no, titlos, timi, availability, anakykl, lianiki) to the TEMP table of ABC databaseHow should i proceed to copy the data to a database ABC and table TEMP?
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
Is it possible to use FileSave to save a richTextBoxs content with a fixed save path, without needing to go thru the save dialogue to select save location.
View 4 RepliesI want to save the value of the TextBox has Apostrophe for example: doesn'tin database sql server?
View 2 RepliesI want to save student detailed in MS SQL SERVER database like names class..... But I have a form such that user can enter one student detailes and then press save. But I want now to allow to have like a spread shit (excel) and then enter all student detailes and when he press save all data are saved like data in name column go to the appropriate one in database>
View 1 RepliesFor example, i installed the windows application in more than one pc. All the pc's are in network. I want to save the data in a single database. How it is possible?
View 7 RepliesI do have Visual VB.NET 2008 Express installed, SQL Server 2005 express installed, and I do know how to start a brand new project in VB.NET, and then add the database to the solution explorer, modify the tables/fields, etc. I know how to create a WinForm, add some controls (and name them and whatnot).....
So in MS Access I know how to use VB in the Code-Behind-Form to use the form in an unbound manner, and insert data into the tables via Visual Basic with SQL statements. I am looking to be able to begin the same sort of thing here, because I guess I have to start somewhere?
i keep on getting SqlException was unhandled incorrect syntax near '+'.i cant seen to see whats wrong with my code.i hope someone can help me solve this code.[code]
View 2 RepliesIs it possible to manually save data from my dataGridView to my SQL server database table?
if it is possible can some please tell me how to do it because i don't like using the data sets and reader VB has because it doesn't give me full control over the procedure.
please see the code below it all works fine its just the last two line im struggling with, which is where i am trying to save the data from the two columns in my DataGridView [code]...
I am using an ajax calendar extender I want to save the records to a gridview on the selected date but i am getting default date like '1900-01-01'.
How to save the date as i am selecting the date in Calender Extender.
I am using Visual Studio 2008 which should be VB.NET 3.0 language.
I have searched and searched for finding the answer on saving content / items in a listbox with strings. As you know the code for saving a text in textbox and get information again in application is[code]...
I am creating a 'log' of everything that occurs in my program. I have deleting and all done, adding the logs and whatnot. I just do not know how to save the logs inside the program beyond closing it.
I want to add content to my listview, it automatically save. Close the program, and next time it runs it will be there.
OK so after a week of aggravating, hair pulling, disaster of trying to figure out what should be simple tasks but beat me down! Ok so I wanted to create a application that would, somewhat manage the users own collection of video games (Lame i know ) you add your games to a listview item, with an image and some sub items, viewing details, using a textbox to search your games... etc i hope you get it
Ok so what i cannot figure out, or find by combing the internet! is how to save all new items the user adds... And including: the item, all the sub items and the picture thats associated with the item.! Instead of posting the code, i posted the application Source code itself here:Source Code , I also started a project here: Codeplex
Later i eventually was thinkin of ading a "wish list" feature where you could add the games you want to get later and also tag it with a release date so when the date comes up, it will let you know, maybe through some alarming way or textbox somehwere... IF you guys want to make it better or fix it! go ahead, i just want this app to save upon EXIT or directing me in the right direction would be VERY VERY much appreciated!
I have got a program with a Rich Text Box, the user enters the data in the RTB which can be super or sub scripted, then saves it in a text file (or any other if text file is not possible). Then another user opens the program and loads that data into the RTB. Would the format still be superscripted or subscripted.
View 7 RepliesI need to add some information to a PDF (Trim Box proporties, actually replace Media Box proporties with Media Box and Trim Box proporties), and I dont have the support in my PDF-motor. So I found out that I can use Notepad++ to open the PDF as a text file and simply add the Trim Box properties as a string and save it. Now I want to do it automatically with vb.net. When I use Stream Reader/Writer the PDF gets destroyed and loses information (Stream Reader dont read all the NUL, SOH, STX etc. I guess). I tried to read the PDF using ReadAllBytes/WriteAllBytes and then it works good, but then I don't know how to replace "Media Box ..." with "Media Box.Trim Box.". I try to use IndexOf but I can only search for single Byte not the whole string. I'm not good in binary and thats perhaps the problem :-). Does anyone have a better way doing it or how do I search for my string "Media Box" in binary?
View 3 RepliesI' successfully created a project fully functional using access database. I've read about SQL connection on VB .net. how to save three text boxes into three fields in excel and a way to retrieve it if I want.
View 2 RepliesI am trying to make a project, but I am beginning and the examples that I see in the forums are giving certain. desire to make a program where web opens definitive page. When opened, the shown content is copied and recorded in an archive. Desire not to copy code HTML, but yes, the text that is appearing in the screen.
View 6 RepliesI have a programme like word and wanna concert the content of the rich text box to pdf and save in the disk?
View 3 RepliesVB
RichTextBox1.SaveFile(FileName , RichTextBoxStreamType.RichText)
This is the way i am saving my rtb files , But it don't save the background color , can anyone tell me of anyway to save the background color or whatever content is on the rtb.
I have 5 column in my unbound datagridview. after user enter all the values i want to save the content to the text file. I want to save one row as one line of text. Then if user open a gridview and enter dataon it then the new data should append with the previous data in text file. Is that posible to do. How can we do this
View 11 RepliesI have been learning a bit of jQuery and .Net in VB. I have created a product customize tool of sorts that basically layers up div and add's text, images etc on top of a tshirt.I'm stuck on an important stage!I need to be able to convert the content of the div that wraps all these divs of text and images to one flat image taking into account any CSS that has been applied to it also.I have heard of things that I could use to screen capture the content of a browser on the server which could be possible for low res thumbs etc, but it sounds a little troublesome! and it would really be nice to create an image of high res.I have also heard to converting the html to html5 canvas then writing that out... but looks too complicated for me to fathom and browser support is an issue.I'm thinking perhaps I could do with two solutions for this. Ideally I would end up with a normal res jpg/png etc for displaying on the website, But also a print ready high res file would be very desirable as well.
View 3 RepliesDoes anyone have any suggestions how I might store the contents of a RichTextBox that also includes images to a MSSQL 2005 database?I suppose a possible answer to this would be to convert the entire content of the RichTextBox to a Byte Array, and then insert the array as a varbinary(max) datatype.But how do I convert the content ?
View 1 RepliesSo I have set up a basic client/server connection and I am trying to send a message to one another on connection, I got the client to receive the message from the server, but the server doesn't recieve the clients message. Here is my current code for reading the sent data from the client:
ServerThread.socket = new ServerSocket(5556);
Socket client = ServerThread.socket.accept();
DataInputStream in = new DataInputStream
[code]....
I was given a task to actually to develop a application where it will automate the process of extracting data values from excel files and add in into access table. Is there any online examples or any advices on how to go about developing this?
View 1 RepliesI am new to using databases in applications and i have a code to select data from the database. However, the first time the application starts, new data is inserted into the database which is needed after. But, the data does not appear until the whole application is restarted. How I can refresh the database content.
The current code for selecting the data is:
Imports System.Data.SqlServerCe
Public Class MSSUI
Dim con As SqlCeConnection = New SqlCeConnection(My.Settings.DB1ConnectionString)
Dim cmd As SqlCeCommand
Dim myDA As New SqlCeDataAdapter
[Code] .....
Im struggling to display the content of my database. I'd like to create a submenu (subpages within pages) to use in my CMS.
Here is my menu so far, as you can see the pagetitles are repeated for each subtitle. I only want one pagetitle to appear for each submenu.
About Us
Your Services
Equality and Diversity Team at SCHS
subpage title 1
[Code].....