we r trying to insert date from datetime picker into mssqlserver 2005 but it also enter defult time(00:00) with it in database. using we want only date... [CODE]& xyzdtp.value.date &[/CODE]

Member Avatar
Member Avatar
+0 forum 12

Hello there, I recently faced problem with my website www.zomedia.in. I am using sql server 2005 and asp.net 4.0 with c#. My database tables are automatically filled with some unknown html css junk codes such as (</title><style>.apyk{position:absolute;clip:rect(438px,auto,auto,438px);}</style><div c) (check http://zomedia.in/ZomediaSongs/ZomediaMp3.aspx and you can see the gridview with junk data in it). This junk data automatically filled my tables without any human intervention. My website was working fine and I did not change any coding that might have cause the issue. So, I cusulted my hosting provider and they could not give answer. Could this be error with coding or server …

Member Avatar
Member Avatar
+0 forum 4

connecting access 2003 database from remote computer .I have a vb2005 application which uses access2003 database. I want to connect to this database via remote computer connected via internet.

Member Avatar
Member Avatar
+0 forum 6

Dear Experts,I want to know how i can sync tables in sql server 2005 and oracle 11g tables. Table structure will be same in both server (sql server and oracle). I would like to prefer some tools available either in oracle or sql server.Thankspardeep

Member Avatar
Member Avatar
+0 forum 1

hello! I got this error when I tried to connect to my db in sql server. > Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 8945dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Could you help solve this problem? I went to Computer > Local Disk (C:) > Windows > assembly and I didn't found the 'Microsoft.SqlServer...' Please help me! Thank you!

Member Avatar
Member Avatar
+0 forum 2

Hello, I need a code that will check if a certain text exist. This is how it's now: If TextBox2.Text = ".sys\clock" Then TextBox1.Text = TextBox1.Text + Environment.NewLine + ("It's") + DateTime.Now End If and I want to make something like this If TextBox2.Text = ".sys\clock" Then TextBox1.Text = TextBox1.Text + Environment.NewLine + ("It's") + DateTime.Now ElseIf .sys\ does not exist in textbox2 then show an error= Textbox1.text=("You didn't used the .SYS\ code") End If I hope you understand...please, HELP ME ! :-(

Member Avatar
Member Avatar
+0 forum 7

I don't know jack about Visual Studio, and I'd like to keep it that way because I like doing stuff on the command line, I have my preferences. But my teacher uses it to compile and I'm curious what I did wrong because gcc didn't throw anything. So, code (Without header, which just defines constants and function names): #include <allegro.h> #include <stdio.h> #include <stdlib.h> #include "midterm.h" void draw(); BITMAP *sc; SAMPLE *clap, *bounce; int color; void start() { score=0; b.sp = speed; b.rad = radius; p.x = width/2; p.y = height-margin; p.length = paddle_length; num_lives=3; num_blocks = 30; top=0; go=0; …

Member Avatar
Member Avatar
+0 forum 3

Hello, i got this error when i click my button save. Error: .Net SqlClient Data Provider: Conversion failed when converting datetime from character string. please help me... this is my save button code: Private Sub btnSimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim check As Integer Dim conn As SqlClient.SqlConnection Dim cmdStudent As New SqlClient.SqlCommand Dim cmdStudent1 As New SqlClient.SqlCommand Dim daStudent As New SqlClient.SqlDataAdapter Dim dsStudent As New DataSet Dim dtStudent As New DataTable If txtKosPerolehan.Text = "" Or cbTarikhJaminan.Text = "" Or txtAksesori.Text = "" Or cbPembekal.Text = "" Then MsgBox("Penuhkan Borang!", MsgBoxStyle.OkOnly) Else If …

Member Avatar
Member Avatar
+0 forum 2

I am trying to build a Web Application using Visual Studio 2005 and C# 2005. I need to accept a date in a particular textbox. I tried to use AJAX Calendar Extender for the purpose. I have added AJAX Script Manager and CalendarExtender controls to the webpage and set the TargetControlId of CalendarExtender to the proper textbox id. But when I display the webpage (using Debug -> Start Without Debugging) and click inside the textbox nothing happens. I even tried to add an image control to the form and set the PopupButtonId of the CalendarExtender to the image, but even …

Member Avatar
Member Avatar
+0 forum 2

what are requirements for sql server 2005 installation? how to connect it with netbeans> can we make no. of instances?how and why?

Member Avatar
Member Avatar
+0 forum 1

[CODE]#Region "Imports" Imports System.Data.SqlClient #End Region Public Class frmcuti Private m_Cuti As New Entity_Penggajian.Cuti Private m_GetHari As New GlobalValidasi Private m_CutiA As New BussinessComponents.Cuti Private m_DS As New DataSet Private m_dta As SqlDataAdapter Private datagrid As DataView Private check As Boolean = True Private Sub frmcuti_onEdit(ByVal sender As Object, ByVal e As FormBase.SaveEventArgs) Handles Me.onEdit Call Edit() End Sub Private Sub frmcuti_onLoaded(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.onLoaded MyBase.Form = FormType.Cuti Call UscIDTextBox1.Initialize("IC") End Sub Private Sub save(ByRef e) Try With m_Cuti .ID_Cuti = UscIDTextBox1.TextBox1.Text .Nik = TextBox2.Text .Tanggal_awal = DateTimePicker1.Value.Date .Tanggal_akhir = DateTimePicker2.Value.Date .Status = ComboBox1.GetItemText(ComboBox1.SelectedItem) …

Member Avatar
Member Avatar
+0 forum 1

Hii everyone.. i have wanted to create a TCP/IP Lan chat program in visual studio 2005. i am a newbie to it 2005. i have already created an interface for it but no codes yet. Attached are images of the client and the server. pls helpppppppppppppp

Member Avatar
Member Avatar
+0 forum 3

I'm trying to figure out the best way to create pie charts using visual studio 2005. Can someone give me some advice? Thanks

Member Avatar
Member Avatar
+0 forum 1

I have uninstalled sql server 2005 but failed to uninstall SQl Server 2005 Management Studio Express. To install Sql Server 2008 Management Studio I need to uninstall Sql Server 2005 Studio otherwise I can't proceed further! Can anybody suggest an easy and clean way to uninstall SQl Server 2005 Management Studio Express?

Member Avatar
Member Avatar
+0 forum 1

In my application some stored procedures are not working properly in current database of SQL Server. I have taken backup of database 2 weeks ago and all stored procedures are working in backup database. I have checked the properties of current database and backup database both are same. After restoring the backup all procedure are working properly but in current database some procedures are not working. Could anybody can help me to solve this problem. Thanks in advance. Joseph

Member Avatar
Member Avatar
+0 forum 3

HI All.. I want to develop a dynamic time table for a school. But the subjects and periods are not fixed ...so there can be any number of rows and columns in this which will be decided by user at runtime. when user enters number of row and columns according to tha ta table layput will be displayed and Each cell of my Table will Contain a Textbox in which user can write somthing.. and when he clicks on save button the entire table will saved as it is.... should i use Gridview to accomplish my need ???? pls if …

Member Avatar
Member Avatar
+0 forum 1

G'day Folks. This is a general question and not a request for code. I have a client with many DTS packages on their sql server 2000. Has anyone had to migrate these buggers to sql server 2005 or 2008? Was it difficult? - After substantial googling/searching I'm not sure I have my head around what Microsoft have done with this aspect of the system.

Member Avatar
Member Avatar
+0 forum 4

Hi guys, I just want to ask some help I added a Download Button in every row of my Gridview. Its function is to download the Binary File of the corresponding row. Whenever i run it it gives me the error "Object reference not set to an instance of an object." Pls help me im just a beginner @_@ Heres my code behind: [code] protected void GridView1_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { if (e.CommandName == "Download") { String[] fileInfo = e.CommandArgument.ToString().Split(new char[] { ',' }); int DocID = Int32.Parse(fileInfo[0]); String FileName = fileInfo[0]; SqlConnection conn = new SqlConnection("My connection String"); SqlCommand …

Member Avatar
Member Avatar
+0 forum 4

i want to generate crystal report using vb6.0 using invoice table which have rate column and total should round up like 63.7 to 64.00 invoice table is in sqlserver 2005

Member Avatar
Member Avatar
+0 forum 2

I'm trying to set up performance dashboard in SQL Server Management Studio Express. I'm currently running SQL Server 2005 SP3 ('product level') and also have installed the Performance Dashboard add-on. A couple of forums I've seen said that I could access the reporting feature by updating the Management Studio Express to the same service patch level as the SQL Server, however the SP3 exe doesn't allow me to do this. It says "The edition of product instance SQL Tools does not qualify for this update." Assuming that this feature is useful to have, do I need to purchase a full-blown …

Member Avatar
+0 forum 0

I am using VS2010 and SQL Server 2005. I have a query to search between dates. Depending on which date I select on the datetimepicker I get no results or limited results, but mostly not all the dates between the two dates I specify. For example, if i select 10/9/2010 on the datetimepicker, the search results are blank. If I select 10/13/2010, then all dates between that date and current date show up. If I select 9/8/2010 or 9/13/2010 on the datetimepicker, I dont get any results. I've tried multiple things and nothing seems to work. My code is below. …

Member Avatar
Member Avatar
+0 forum 2

Hi, I have a problem with an VB aplication programmed in Visual studio 2005. Recently i was upgraded my computer with windows XP to Windows 7 Ultimate (fresh instalation). After that I made reinstallation Visual studio 2005 and service pack 1 for Vista/win7. My problem now is when I run my old VB project (made by same version VS2005 on XP), I can't see anything on form (Form1.vb) of that application. I Can see my code in Form1.Designer.vb and everything is running well, only I can't do any changes on form (editin old or adding new components), because I see …

Member Avatar
Member Avatar
+0 forum 1

Hi, I am just new using the Microsoft Application Blocks .NET. I am using a custom one... The problem is that when I call the SqlHelper parameter as "SqlHelper. " it only shows to me "Equals" or "ReferenceEquals". Why I can get the others...? [CODE]public void ExecuteNonQuery(SqlCommand sqlCmd) {...} public SqlDataReader ExecuteReader(SqlCommand sqlCmd) {...} [/CODE] What I am missing? I did this: 1. I downloaded the MS Application Block .NET and then using the Data Access Block I ran my custom code there to get the .dll. Just copy and paste to replace the original code... It gave to me …

Member Avatar
+0 forum 0

I am trying to develop a subroutine that will send an IM to a user. The idea being if the user is online, the code sends an IM to the user via communicator. If the user is offline, it sends an email. The code does work, in that it does open the communicator window, but it does not send the message text. I am testing this off a button atm, but the code sample I found used Communicator 2007 -- there is no SendText() method in Communicator 2005. I have been unable to find a solution online, so I am …

Member Avatar
+0 forum 0

Hello all ... i'm still new in linux networking ... my office use mandriva 2005 w/ samba as the file server and all client using win Xp to access the shared folder on that server I need your help about these matter : 1. how to config mandrake/samba to detect file deletion on samba server. 2. how to set access right to samba user, so the user can only create/modify file and can't delete the existing files Thanks in advance..

Member Avatar
Member Avatar
+0 forum 2

Hello, Using visual studio 2008 environment, i would like to change a classic windows application design, so i'm wondering if there is an idea a bout this. i've find some skins like irriskins ([url]www.sunisoft.com[/url]), but i'ts not what i'm looking for. is anyone have any idea, any help will be very appreciated. Thank You

Member Avatar
Member Avatar
+0 forum 1

I am exporting a large amount of data from SQL Server 2005 to Excel. Most of the data appears as I want it to- without the exponential notation. Any values [I]smaller [/I]than 0.0001 (i.e. four zeros to the right of the decimal) are displayed as, for example, 7E-05 rather than 0.00007. I know that I could use a fixed format, however the values in this field have a broad range of precisions (e.g. 1250, 1.3, 0.00345, 0.000001) and I would like to maintain the original number formats. I also realize that Excel can convert exponential notation to non-exponential, however I …

Member Avatar
+0 forum 0

i want to do back up for my project.............. and to copy the database from d:\ drive which uses it as default .... to other location

Member Avatar
Member Avatar
+0 forum 1

Hi, My project modules are organized in such a way that I have to maintain following Database structure. I've 5 schemas, each containing 20 to 50 tables. Each schema is accosiated with one module of the project. All the tables that are used within more than one modules are kept in "COMMON" schema. Each module takes 2 to 5 months to finish. So when first module is finished we are opening it for use, and continuing with the second one and so on. Meanwhile real data is being inserted into the finished module's schema. Also table definitions of the finished …

Member Avatar
+0 forum 0

Hi, My project modules are organized in such a way that I have to maintain following Database structure. I've 5 schemas, each containing 20 to 50 tables. Each schema is accosiated with one module of the project. All the tables that are used within more than one modules are kept in "COMMON" schema. Each module takes 2 to 5 months to finish. So when first module is finished we are opening it for use, and continuing with the second one and so on. Meanwhile real data is being inserted into the finished module's schema. Also table definitions of the finished …

Member Avatar
+0 forum 0

The End.