chmonalisa

Thanks Muhammad. This is really a gud article. Regards, chaitanya

you can start the default website by typing "net start w3svc" in the command prompt. You can also do this one: write net start w3svc in a text file and save it with extn .bat keep this file in ur starup folder. This should work. Thanks, Chaitanya.:surprised

buddy, Try developing an internal Chat application for you college. You better take c# or vb.net to code this. This should be a challenging task for you. Thanks, Chaitanya.

[quote=ManicCW;251802]Is your column [B]deptCode[/B] string (varchar, nvarchar ...) type?. LIKE operator should be used only for string values.[/quote] hello try this ;) Const strSQLD As String = "select distinct deptCode,deptName From view1,table2 where deptCode like '" + strV + "%' order by deptcode" You have to keep strV outside the …

hey buddy,:lol: first you need to add up the linked server EXEC sp_addlinkedserver @server = 'server1', @srvproduct = '', @provider = 'sqloledb', @datasrc = 'LocalServer' then add linkedserverlogin EXEC sp_addlinkedsrvlogin 'server1', 'true' then write up the query as [server1].Database.dbo.fn_test(@test). reply me if u need further info. Thanks, Chaitanya. :cool:

hey Balaji, Try this use dataview to filter your table and assign this dataview to your datagridview control. DataView dv new DataView(ds.Tables[0],"studentid=2343","studentname",DataViewRowState.None); reply me if you have any concerns. Thanks, Chaitanya.

hey buddy, try this open a sqlcommand object and execute your search query. take those results in a dataadapter and assign to a dataset then load the dataset to an xmlfile. you can do that. it's easy. Finally using response.binarywrite u can flush the xml content to your browser. thx …

Hi, Attached is the code. find the attachment and shoot out ur queries.:) gud day bye 0 then lobjconn.ConnectionString= "provider=sqloledb;server=ravigopal;initial catalog=expense;integrated security=true" lobjconn.open lobjcmd.activeconnection=lobjconn lobjcmd.commandtype=1 lobjcmd.commandtext="select text1 from country where id=" + lstrid lobjcmd.execute() lobjconn.closeend if%>function fnsubmit(optid){ document.form1.method="post"; document.form1.action="sample.asp?id="+optid; document.form1.submit();} 0 then lobjconn.ConnectionString= "provider=sqloledb;server=ravigopal;initial catalog=expense;integrated security=true" lobjconn.open lobjcmd.activeconnection=lobjconn lobjcmd.commandtype=1 lobjcmd.commandtext="select …

vb6 is gud enough for mobile applications. What you need to do is an SMS Engine which acts as a mediator between your vb application and Mobile. Generally all the Cell Operators buy these Engines and use them.

hello Please correct me If i am wrong. What you need is to create a table in ur database and store the details whenver a user runs the test . right? if it so then here it is simply use a command object sqlcommand.commandtext="create table table1 (col1 varchar(10),col2 varchar(20)" sqlcommand.executenonquery() …

buddy, You can install Sql Server edition in Windows XP. So what you might have installed is the server edition. Try to remember while installing you might have selected windows authentication or mixed mode. if mixed mode then it should have asked you for administrator password generally sql server administrator …

hey buddy, you can update the views with a single update statement update dbo.view1 set col1='washington' where country='USA' But if you insert some new records in the table, they will automatically appear in the view as a view does nothing but gets the data from the table. but if you …

michael, in this case you should write this. SELECT * FROM table WHERE charindex('abc',field)>0 this should work thanks, chaitanya

buddy, here it is select t2.loginname,t2.wrknum,t1.time,t3.description from table2 t2 left outer join table1 t1 on t1.loginname=t2.loginname inner join table3 t3 on t3.worknum=t2.worknum Thanks, Chaitanya.

Hi Mark, Here is the code. I never tried this before as I didn't need it till now. But as I have seen ur query I thought I should do this. See the code Just copy and paste and see whether it is running. Make sure you write [B][I]use 'database …

hi mayur, This is pretty tough to implement unless you have to time to write down the code. use xmldocument to load the xml file. use selectsinglenode() method and loop through all the nodes. compare each element value with the content in the word document. to load word documents see …

hi plazmo, You can only edit an xml file by loading it completelely. Since many users hit this xml file , there is every possibility of data loss. If you want to view only a small content from the xml file, write an xsl file to show only what is …

hey andrew, Try this, save the file name with a unique no. and the unique no. is day() & month() & year() & hour() & min() & second() thanks, Chaitanya.

sameera, you better use this.. dim rs set rs = rs.nextrecordset '' do ur operations rs.movenext thanks, chaitanya.

hi kumaran, You can do this by capturing the user's ip. get the client's ip by using Request.ServerVariables("REMOTE_ADDR"). also assign a unique id to this client and save it in the application variable application("id")=#JSDSDLFJ when he tries to open a new site, just check these and block it :) Thanks, …

Hi Kumiko, Your code is very lengthy and it's difficult for me to go through it completely. I suggest something for ur problem.. You want to keep paging intact while you search. right? if this is the case then here go pass the pageno. querystring whenever you are searching. this …

hello, try this :!: [B]conn.open "Provider=SQLOLEDB.1;Persist Security Info=False; uid= ikim; pwd=ikim;Initial Catalog=ol;Data Source=localhost"[/B] Note that u mentioned "pasword" instead of "password". if you dont' remember the password u can also use this [B][B]conn.open "Provider=SQLOLEDB.1;integrated security=true;Initial Catalog=ol;Data Source=localhost"[/B] [/B]which takes windows authentication mode instead of sql authentication. Thanks, Chaitanya.

hey karthik :cheesy: You have to save the image to ur server. Unless you do this you cannot do anything with that image. If the user presses "save" then you get the saved image path and do you operations. If he doesnot click "save" and goes to another page then …

HI Siya, You cannot send an SMS through ASP.NET unless there is an external host which processes your requests. There are two way you could do this. 1)prepare an XML message and dump in a public queue of your system. If there is any external online application then it should …

hello, You didn't specify the exact error you got..:p Neverthless try these: 1)in the command prompt type IISRESET and click ok 2)in an IE window address bar write [URL]http://localhost[/URL] and check whether your localhost home page is opening or not. If not then try with [URL]http://localhost:80[/URL]. If you are not …