|
Dear every one...
Hope you all will be fine and read this in good of your health.
I have a problem that what is the best way to save, edit, insert, update etc. my record using a complex form.
PICTURE IS THIS;
I have a form Students.VB
I have many controls on the form as under
Listboxes
Textboxes
Checkboxes
buttons
now i want to know following things....
1. How i will fill my listbox with Student Names using data reader object (Database School is in MS ACCESS and table Student with fields ID,NAME,AGE)
2. how i will fill my comboboxes with CITIES, STATES, COUNTRIES etc.
3. what is the alternate of listbox.itemdata property in vb.net
etc. etc. etc..
please give me a detailed help that can clear my concept.
|
|
|
|
|
in all cases, the answer is the datasource property of hte controls, which will take a datatable, a dataview, an array, you name it
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 )
|
|
|
|
|
dear friend.
thanks for information.
its ok in all senses i have build. then tell me that if i have a combo box filled with Brand names and behind the scene i am saving the Brand ID for each brand name.
in vb 6, i used dataitem property of combobox to save a brandid with every brand name,
now what i should do with the same contol
thanks
|
|
|
|
|
Use the DisplayProperty and DataProperty properties ( from memory ) to set a displayed and a hidden value. This will not store them in the DB, but it will load them from the DB for you to use with the control.
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 )
|
|
|
|
|
You may also set your combobox datasource to datable... and set its displaymember and valuemember....
ComboBox1.Datasource = Dataset.Table("DataTable Name")
ComboBox1.ValueMember = "Field Name" -----> Hidden Value
ComboBox1.DisplayMember = "Field Name" -----> Visible Value
|
|
|
|
|
in my appliaction i use ado.net and connect to sql server 2005 . i use the sql server authentication and to connect the db via the application i have to pass the password and uer id with connection string ,
I want to encrypt them and how to do it ..
thanks 
|
|
|
|
|
String connectionString;
String user = System.Configuration.ConfigurationSettings.
AppSettings["mappedname"];
String pass = System.Configuration.ConfigurationSettings.
AppSettings["mappedkey"];
connectionString = "data source=myserver;initial catalog=northwind";
connectionString += ";user id=" + user;
connectionString += ";password=" + pass;
sqlConnection1.ConnectionString = connectionString;
String user, pass, connectionString;
user = Microsoft.Win32.Registry.LocalMachine.
OpenSubKey("Software\\Connection").
GetValue("mappedname").ToString();
pass = Microsoft.Win32.Registry.LocalMachine.
OpenSubKey("Software\\Connection").
GetValue("mappedkey").ToString();
connectionString = "data source=myserver;initial catalog=northwind";
connectionString += ";user id=" + user;
connectionString += ";password=" + pass;
sqlConnection1.ConnectionString = connectionString;
Rami Abd alhalim
|
|
|
|
|
Hi this is my query to auto generate one field value...,
select @empId=isnull(max(empId),100)+1 from tbltempemployee
This will generate the number 101,102,...etc
But i want to store the value as L101,L102,...,
It means while auto generate the value i wnat to add one more alphobet letter before that value and store...,
How to do that,
Plz any one hlp me,
Magesh
|
|
|
|
|
set @empID = 'L' + @empID
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 )
|
|
|
|
|
Hi Magesh,
The case when only one alphabet is used:
select @empId='L' + cast(isnull(max(substring(empId,2,len(empId))),100)+1 as varchar) from tbltempemployee
The above query will take the max of the existing records leaving the first character and will add "L" to it.
Senthil
|
|
|
|
|
halloo ..
i'm newbie in ADO.Net.
i want to ask about trigger in sqlserver2000.
i develop ado apps with c#. my case is ...
client 1 open add employee form, client 2 open list of data employee.
client 1 add employee data. if client 2 doesnt click button refresh, so new data is doesnt appear, right ? so i want sqlserver make the trigger to the client and auto refresh the list data so that the data auto appear in list without user in client 2 click resfresh button or the application make auto refresh with function.
thanks.
thanks vian.
|
|
|
|
|
Please don't cross post.
No, you can't.
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 )
|
|
|
|
|
you can not do that
Rami Abdalhalim
|
|
|
|
|
so, i still must refresh in form list data ?
|
|
|
|
|
you need to timer at 1 sec refresh data just
Rami Abdalhalim
|
|
|
|
|
hi all,
i have a value entered by user into a text box, i want to search the table for the detail of the entered text.
plz provide me with the syntax to do such thing
Regards
|
|
|
|
|
you need to use LIKE operator to search for a given string.
SELECT Column1,Column2 from Table1 where SearchColumn LIKE '%' + @SearchString + '%'
hope this helps...
Regards
John
|
|
|
|
|
this solution if you use string
Select * from tableName where ColumnName = '"+textbox.text+"'
this solution if you use integer
Select * from tableName where ColumnName = '+textbox.text+'
Rami Abdalhalim
|
|
|
|
|
Hi,
Which Rights are needed to create and replace view in oracle, that user already have rights to create view, but it get the insufficient privileges while creating a view.
Best Regards,
Mushq
Mushtaque Ahmed Nizamani
Software Engineer
Ultimus Pakistan
|
|
|
|
|
hi i have java script code for uploading images or files for a joomla component and i am not able to store this images or files in data base tell me the procedure for storing the images in a data base and i don't no data base in depth please let me know its urgent..........
|
|
|
|
|
Sorry, but there is no Access forum.
In a sub-form for detail lines, I'm trying to respond to the entry of a bar-code, using the After Update event of the bar-code combobox, where I set the Product name textbox in the same detail line to the ProductName value in the combobox. I'm sure I've done this before, and it only affects the current record, but now when I update the bar-code, the text the product name textbox in ALL lines gets updated.
Private Sub ddlProduct_AfterUpdate()
txtProductName = ddlProduct.Column(2)
End Sub
I do not believe they are right who say that the defects of famous men should be ignored. I think it is better that we should know them. Then, though we are conscious of having faults as glaring as theirs, we can believe that that is no hindrance to our achieving also something of their virtues. - W. Somerset Maugham
My New Blog
|
|
|
|
|
I couldn't add new registration in SQL Server2000 using SQL Server Authentication mode even I've already entered correct server name, username sa and correct password.
I've tried to ping this server from command line and it's ok.
But if I run Windows Explorer (\\servername) and put Windows'username and password then add new registration again, it's successful.
Please explain me why? I want to add new registraion from some server which I only have SQL Server username and password but don't have Windows username and password. Is it possible?
adfafafa
|
|
|
|
|
hdtrung wrote: Please explain me why?
Does the server process accept remote connections? Is there a firewall blocking the TCP port it is using?
Have you installed a named instance? If so, then you need to specify the name as well as the machine.
-- Always write code as if the maintenance programmer were an axe murderer who knows where you live.
Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ...
* Reading: SQL Bits
My website
|
|
|
|
|
Hi Colin Angus Mackay,
I used default instance (MSSQLSERVER) when installing the server. I think there's no problem with TCP port or remote connections(no firewall,my computer and server are in the Wide area network).
The server is also running in SQL authentication mode. That's why I gave username sa and password when adding new registration.
Following are all the complicated steps I must do to add new registration:
Ping SERVERNAME to check connection
Add new registration, using SA and SApassword
The previous step failed, then run windows explorer (\\SERVERNAME)
Put windows logon info: SERVERNAME\trunghd & mypassword
Add new registration again and it's successful
If I add registration from some server that I've already entered windows logon info once, it's successful too.
The question is why I have to give Windows logon information to the server when it's running in SQL authentication mode. I found no relation between my Windows username in this server with the installed SQL server in it.
Thank you very much for your answer.
adfafafa
|
|
|
|
|
HI All,
I have a frustrating problem with continual login failures with SQLExpress 2005.
I have an application that behaved until yesterday when I started adding some extra Crystal reports.
I get either of two errors:
1. "Cannot open user default database. login failed for TECRA\Nigel"
Or
2. some big long system error (32) saying the file is in use.
When first entering VS, I can either create a dataset or open server explorer, but after that trying to do either throw the error(s).
To clear the error i have to close down VS, restart SQL server manager and reset IIS, but it is back next time I try to do anything with the DB.
Folder permissions are OK for both ASP.NET and NETWORK SERVICE. I have even resorted to deleting the new reports and datasets but now I get the errors regardless.
I am sure I must have done something to the DB, or maybe there is a dud connection somewhere, but I have limited knowledge of SQL Server Manager Express so don't know where to look to stop the errors.
Connection string is:
<add name="cs_BigShakti" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\SHAKTI.MDF;Integrated Security=True;User Instance=True; Connect Timeout=30;Initial Catalog=SHAKTI" providerName="System.Data.SqlClient"/>
Many thanks in advance,
Nigel
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
