[microsoft:sql-server] Forum Topics

Hi Everyone, I am making the jump from vb6 to VB.Net, so if you find some of my questions naive, please bear with me. My current problem is that I am working in Visual Studio 2005 and have created a Windows application. In the application, I have 1 data set …

hi guys, im having some trouble here and cant figure out what im doing wrong. i have a vb6 program linked to a ms database and im running queries and returing the results in a listbox on the same form. here is what i have: [CODE]Private Sub cmdSearchauthor_Click() Dim strSearchFor …

hi.. i'm facing a new problem in ssrs reports ... i have hosted an asp.net application which is running fine in XP.. but when i open the application in UBANTU OS application is working fine but reports in kannada are not displaying it is displaying some russian character .. same …

[CODE]I am having two tables in MS SQL SERVER 2005 in master database. 1st table is Country & 2nd is City. [COLOR="Red"][B][U]I want to know the command for Copying a Column(with values) for eg say Name from City Table to Country Table. Column is not empty, its having values(data entries). …

Hello again, I have a problem with dropdownlist. DropDownList: [CODE] <asp:DropDownList id="ddlStudents" runat="server" CssClass="textbox" OnSelectedIndexChanged="ddlStudents_SelectedIndexChanged" AutoPostBack="True" EnableViewState="False"> <asp:ListItem Value="0">Choose</asp:ListItem> </asp:DropDownList> [/CODE] Method which fills the ddl with data from DB [CODE] protected void GetStudents() { SqlConnection conn = new SqlConnection(connection); SqlCommand cmd = new SqlCommand("GetFullStudentProfile", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText …

i have combobox in which membership_desc=gold,silver,platinum is displayed and have textbox in which i want that fees displayed automatically in it as gold=100 silver=200 platinum=300 [CODE]form_load(); combobox1.datasource=ds.tables["membership_details"]; combobox1.displaymember="membership_type"; combobox1.valuemember="membership_id"; combobox1_selected_index_chanded(); da.selectcommand=neew sqlcommand("select membership fees from membership_details where membership_desc='"+combobox1.selectedvalue+"'",cs); textbox7.text=??????????????????????????????????????????[/CODE] as i do binding of text box it show ERROR that …

Hi everyone, I am new to this board. I am trying to figure out how to set up an SQL statement to grab a record from a database when I'm not sure what column/field the string I am looking for will be in. for instance: I am looking for "ABCDEFG", …

As i click update button data is updated but all the data in the table get with it....(same data in whole table) suggest me what i doing WRONG in it.... [CODE] private void btnUpdate_Click(object sender, EventArgs e) { SqlConnection cs = new SqlConnection("Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"); SqlDataAdapter da = new …

i want due date comes automatically as by adding after 15 days from date of issue................. [code] private void btnIssueBk_Click(object sender, EventArgs e) { SqlConnection cs = new SqlConnection("Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(); cs.Open(); da.InsertCommand = new SqlCommand("Insert into Lib_issue_details Values(@book_tag_id,@member_id,@book_issue_on,@book_due_date)", cs); da.InsertCommand.Parameters.Add("@book_tag_id", SqlDbType.VarChar).Value = textBox2.Text; …

Hi, I looking for a solution for how to check if a connection to a remote computer exist or not using vb.net. I 'm writing a program which will request data from a remote sql server. I need to check if the connection to the remote server exist, before open …

Hi , I am new to VB.NET.I am creating an database windows application in VS2010 and SQL server 2008 express.In one of my form i have a datagrid. My requirement is that i want to display the sum of an column of a DB table and other related data from …

Hi, i have convert my code from sql to mdb but there is problem when it comes to place i highlight in red it doesn't execute the command reader....it end the application when it reaches [COLOR="Red"]Do While dr.Read[/COLOR]can any1 tel me whats the wrong with my code.....i'm totally blank ! …

can any one please help me with this... I am trying to load a treeview and listview from sql database but did not work.... so if any one know how to do that please help me with it.... Thanks vince

i am trying to create a dataset for use with crystal reports. i have a dataset called dataset.xsd with two tables BatchHeader and BatchDetail these have a relationship of BatchID on both tables. (see picture1) I have this working when there is only one table in the dataset with this …

I'm doing a project involving VB.Net 2008 and SQL. I'm trying to make a combobox display whats in the sql database that is connected on the left hand side. how do i do this? Sam

I keep getting the following error when I try to add new record into database (Access 2007) "The INSERT INTO statement contain unknown field name:'login'." I dont whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the …

i have table in sql server 2000, in whicn i have coloums. now on the interface i have one text box as customercode, and four (4)combo boxes with differnt values. when user wants to do entry, he will enter any code, and will select values from combo boxes, and when …

Hello guys. I'm developing a web application in which I have to connect to a mssql server which is connected through a proxy server. I have allowed data transfers for the MSSQLSERVER service, and allowed connections for port 1433. I've read that this is absolutely insecure, and it still gives …

Hello, I'm trying to sort a training table in order of the sequence of tasks. These tasks are numbered 1.1.1 1.1.2 1.1.3 ...... 1.1.10 1.1.11 When the query sorts this and displays it, it comes up: 1.1.1 1.1.10 1.1.11 1.1.2 .... Is there a way to get them to come …

Hi all, I have had a look around the forums but i could find anything, if someone could point me in the right direction for this. What is the best way to handle an sql connection, in my program I have to get data from the server on a button …

i have the following code [CODE] Dim i As Integer i = Me.GridDomains.CurrentRow.Index Me.lbdomainid.Text = GridDomains.Item(0, i).Value [/CODE] when i have complied it in visual studio 2010 (debug) i get a error saying system.data.sqlclient.sqlexceptions conversion faild when converting varchar value LBdomainID to data type int. in sql the datatype is …

Hello Everybody! I have the following problem: I want to make an application, which need tables to show, edit, etc. You would be able to select the table, which you want to work on, by a dropdownlist (the whole project is in ASP.NET). I want to load the selected table's …

Dear All , I need to backup the sql server 2005 express database . It works fine if I make backup to specific folder"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup" . But if I change the path to any other path . I got an error "Backup failed for Server 'server name'. " …

hi i have this form, and a subform datasheet.i need to copy selected row/record from the datasheet to the corresponding textboxes. i have used this, but it will copy the whole column title and the record, and i dont know how to separate the string of copied data into textboxes, …

hello everyone i have a "text box" in which i have to put" member_id" and fetch records as number of books issued to that particular "member_id".... database tables are lib_member_details and issue_detIails... issue_details=tag_id,member_id,book_issue_on,due date... suggest me the code for this problem in c# with sql also help me that can …

good day for all i want to know how i can make linked tables in access with sql server 2008 i tried with odbc in access 2003 but i can not please help me i tried with Microsoft SQL Server Migration Assistant 2008 for Access but i can not

Hi, I have a database with two tables tblCustomer - Name string - Surname string - ID Card string (PK) - CityID int (FK) tblCity - ID int (PK) - Name string Now i want to show all the customer details but i would like to show the name of …

Hello. I am doing an exercise and faced an problem my code is: [CODE] protected void ddlStudents_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(connection); SqlCommand comm = new SqlCommand("GetFullStudentProfile",conn); comm.CommandType = CommandType.StoredProcedure; comm.CommandText = "GetFullStudentProfile"; SqlDataReader reader; try { conn.Open(); reader = comm.ExecuteReader(); reader.Read(); StringBuilder sb = new …

I want to create a 3 page search to bring back one result from a SQL database. The first page will be a image of a male and female, and the user selects themself, e.g either Male or Female. They click next. The next page asks for the day of …

hi, for a 'total cost' field in sql i used the data type 'money'.. in c# what data type should i use to match that of the sql?? decimal or float?? thanks

Hello folks, I beg your pardon if I have posted the thread in wrong forum. But my query is related to sql server and visual basic 6, so I thought posting it here rather from visual basic forum will help me getting most replies.... I have developed an client-server based …

I want to make to security question just like the one attached in one of my project........can anyone tell me how to do that.........here i'm planning to save the answer in sql server...........is it possible to do that............

I have a text box which I search SQL server which returns to values based on the text I pass the SP and then I want to add to the list box items so here is my code below the DataTable contains the item I want to return in the …

Good day, i have a problem regarding about adding a record to my database, i want to insert a record that not exist on my table, the record that i want to add to a field is not related to other table. This field should be related to other table …

Hi Guys Could you please let me know what SQL query I can run to get the parent of a specified table? I already used this code which is providing a list of child tables [CODE] SELECT object_name(parent_object_id)As 'Childs List' FROM sys.foreign_keys WHERE object_name(referenced_object_id) ='Stores' [/CODE] How can I run …

I am trying to create a view and by linking two tables together, VLP_QC_Results_Batch1000 and VLP_Stock_QC1000. (see below pics) The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“ I need to link these so that we can …

Hi all.... i have found code that displays treeview and listview from database but it is done for microsoft access ... i am try this code for sql sever but end up only in exception,..... can any one modify this code to access the sql database and display the listview..... …

anyone help with this? I have a unique id on each line of sql, i want to be able to update a row from a table i tested and tested this but unable to get this working. does anyone know how i am able to do this? [CODE] Dim PINV …

afternoon everyone, I am new to using MSSQL and need help with SUBSTRING function. i have a strings like below s2-Total Solids - Std Method V1E-RVT4/2.5@20degC Initial V1Y-LVT2/60@20deg Initial A2-Alkalinity - ISO Method(%) I would like to only get the data before the first "-" IE s2 V1E V1Y A2 …

So how can you tell if you've maxed out express and need to move to the full blown version. Not referring to database size but performance? Asking because we are moving a website and the webhost master asked if he will be on express or full version claiming that express …

HI I want to create new sql account in sql server 2005,and user only able view sql agent job history details only.How do I do this.Please help. Thanks Tank50

hello friends, I am new for VB.net, and currently m facing a problem, that is huge problem for me right row, may be that is not a big problem for you guys..I want to use DataGridView in my project, and in DataGridView, i want to navigate focus using enter key …

Hi everyone, Here i am once again, I have a business logic layer, which will be called upon by aspx page, The BLL has a SQL statement which add's records on to the database, which works fine, however i would like to make sure the record that is being added …

Hello everybody and thank you in advance for taking the time to read this. I am having trouble connecting to a remote MSSQL server from our web page server using the SQLSRV Connect. I have installed all the necessary php extensions and sql drivers, and they all appear as they …

Hi Guys, I am trying to list the name of all tables which belong to a selected database from the comboBox1(which is populated from SQL Server 2008).I used the following code but it seems it is just adding all System Tables! to listBox1 instead of choosing tables from selected database. …

Hello, I did a stupid mistake in which I had my date saved as varchar in the format: "Tuesday, 25 November 2011". Now my database was binded with a datagrid and the problem now comes when I am sorting the grid from date as it sorts it with week day. …

Can anybody please explain me this expression? CONVERT(datetime, CONVERT(varchar, GETDATE(), 1) thanks.

Hi, I am new to ASP.NET and i have been thrown into the deep end on a project, the person who created this code is no longer available. The website allows an Admin to login and edit, update or delete information in an SQL database referring to PDFs located on …

i have the following code which works fine where there is data in the table. when the table is empty and there is no data in the @Ctotal varible i get my error MessageBox.Show("Unable to get Claim Total") is there anyway i can ignore this if there isn't a value …

Hello, My code is: [CODE] protected void Button1_Click(object sender, EventArgs e) { string EducatorName = tbEducatorName.ToString(); string Educatorfamilyname = tbEducatorFamilyname.ToString(); int Hisclass =Int32.Parse(ddlClasses.DataValueField.ToString()); SqlConnection conn = new SqlConnection(DBconn); SqlCommand cmd = new SqlCommand("AddNewEducator", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddNewEducator"; cmd.Parameters.Add("@EducatorName", SqlDbType.VarChar).Value = EducatorName; cmd.Parameters.Add("@Educatorfamilyname", SqlDbType.VarChar).Value = Educatorfamilyname; cmd.Parameters.Add("@EducatorClass", SqlDbType.Int).Value …